Skip to content

CSV data transformation on edit #64

@frigvid

Description

@frigvid

Hello,

The addon currently modifies the original formatting and structure of the CSV file upon entering a cell or otherwise editing the table with the addon active.

  1. Data with extra spaces are truncated in view. E.g. "FOOBAR / 0 " becomes "FOOBAR / 0" even though it shouldn't be truncated, given that it's CSV and there's probably a reason that the data is how it is.
  2. All double-quotes are removed upon entering a cell or otherwise modifying the table. Though double-quotes aren't always required, it's the same issue as the first, in that there's probably a reason the data is enclosed in double-quotes.

To give a bit of context for why I think this is important: I work with datasets that are exported, transformed in some fashion, and then imported again. Modifying that data with this addon looked promising, especially due to this line in the README "Preserved CSV Integrity: All modifications respect CSV formatting—no unwanted extra characters or formatting issues," but it's currently unusable for my use-case due to the formatting changes that are applied when editing via this application.

Regards,
Frigvid

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions