Skip to content

Clean and or change the format of the CSV file exported from the application #22

Description

@Skids-1

The provision of a text output is a great idea but unfortunately the use of the CSV format is not so great. CSV is wildly described as being a poor export / import file format mostly because the item delimiter, a comma, is frequently used in text that appears as data payload. The present output writes out five data elements : Filename,Filepath,Title,Caption,Keywords. Issues occur when trying to parse Title and Caption. While it can be achieved it either involves making the assumption that the Title will never include a comma or having to count quote comma pairs and process accordingly.

I suggest that a better solution would be to either default to an uncommon character such as pipe "|" or tilde "~" or allow the user to specify a delimiter. The use of ASCII 31 (Unit Separator) and ASCII 30 (record Separator) overcome all the issues of CSV including the use of multiple paragraphs in blocks of text.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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