You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Running the 'input' command on a CSV with malformed quoted strings fixes them enough that they are able to be processed but modifies the data inappropriately.
For example, the following problematic column value in one of our test files:
"Choices "contact us" email address"
Note: the two spaces between "Choices" and "contact us" are in the original data.
Gets changed to:
"Choices contact us"" email address"""
But it should be:
"Choices ""contact us"" email address"
The command being run is:
xsv input <malformed-file> -o <target-file>
This is a very consistent error that, although allowing processing of the data (i.e. conformant parsers now accept the files), it subtly (and unacceptably) changes it in the process.
The text was updated successfully, but these errors were encountered:
I understand the request, but it's not reasonable to support. If your data is malformed, then that's the problem you should fix. It being malformed makes it impossible for xsv to choose a correct interpretation in every case and exposing options to control how different classes of malformed data are interpreted is not something I'm interested in doing.
Running the 'input' command on a CSV with malformed quoted strings fixes them enough that they are able to be processed but modifies the data inappropriately.
For example, the following problematic column value in one of our test files:
"Choices "contact us" email address"
Note: the two spaces between "Choices" and "contact us" are in the original data.
Gets changed to:
"Choices contact us"" email address"""
But it should be:
"Choices ""contact us"" email address"
The command being run is:
xsv input <malformed-file> -o <target-file>
This is a very consistent error that, although allowing processing of the data (i.e. conformant parsers now accept the files), it subtly (and unacceptably) changes it in the process.
The text was updated successfully, but these errors were encountered: