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
col1, col2, col3
1,"this is fine",2
3,"this is not \"fine",4
5,"this will still be part of the previous line",6
7,"this will end the line started at \"3",8
9,"this will cause a \"stray quote\" error",10
There should probably be different behavior for escaped quotes. Probably ignoring them. This causes some interesting problems when dealing with 30,000 line files where there are precisely 2 single instances of escaped quotes about 10k lines apart.
Also I'm not sure if escaped quotes qualify as stray quotes. My solution was to remove the 2 that didn't have matches, and replace all escaped quotes with single quotes, but it wasn't a graceful solution.
There should probably be different behavior for escaped quotes. Probably ignoring them. This causes some interesting problems when dealing with 30,000 line files where there are precisely 2 single instances of escaped quotes about 10k lines apart.
Also I'm not sure if escaped quotes qualify as stray quotes. My solution was to remove the 2 that didn't have matches, and replace all escaped quotes with single quotes, but it wasn't a graceful solution.
this is the validation that failed interestingly: http://csvlint.io/validation/5789206163737627b90004bb
The text was updated successfully, but these errors were encountered: