4 ms·

Happy to receive some feedback. It does not ignore empty cols/rows. I am not sure if it handles quotes commas. Will definitely look at both issues and the CR

Happy to receive some feedback. It does not ignore empty cols/rows. I am not sure if it handles quotes commas. Will definitely look at both issues and the CR/LF issue, thanks for reporting. I am not a CSV expert yet as you might have noticed. Is this a tool that you would use if these issues are resolved?

gus_massa 6y ago
There are like a million of variants of CSV. They have the same problem than regular expressions or markdown. Each implementation adds a new trick, or feature or special case, and all of them are slightly incompatible. I usually just open Excel. One of the problems/features with Excel is that it use the local configuration to write the csv. I'm from Argentina, so IIRC the default configuration is to use semicolons instead of comas, and the decimal point is a coma. (Add that to the feature request list, but perhaps you can try to adapt to the USA market first, that is more uniform but has enough configuration options.) Sometimes I need a csv, but the the other program only understands the non-localized version of the csv, so I have to open it in a text editor and replace the semicolons with comas. I sometimes use the version of csv that use tabs instead of comas, it it probably worth adding soon. And there is an option to use many spaces to keep the data in columns. Also, there is an old post by patio11 about reading csv instead of writing them: https://www.kalzumeus.com/2015/01/28/design-and-implementation-of-csvexcel-upload-for-saas/ https://www.kalzumeus.com/2015/01/28/design-and-implementati... (HN https://news.ycombinator.com/item?id=8960280 https://news.ycombinator.com/item?id=8960280 | 107 points | Jan 28, 2015 | 35 comments) Perhaps it has something relevant.
- robbiejs 6y ago
  When is programming ever easy? The app uses PapaParse which is a JS lib for parsing/converting CSV to JSON and vice versa. I believe it has many settings built-in, tab-vs-comma delimiter (or somicolons), etc. (see here: https://www.papaparse.com/docs#config https://www.papaparse.com/docs#config). Right now, I am using defaults. I think I will add an "Advanced Save" option that lets the user tweak the CSV export format. Hopefully PapaParse takes care of that, best case scenario... :-) Thank you very much for your comments!

gus_massa 6y ago

There are like a million of variants of CSV. They have the same problem than regular expressions or markdown. Each implementation adds a new trick, or feature or special case, and all of them are slightly incompatible. I usually just open Excel. One of the problems/features with Excel is that it use the local configuration to write the csv. I'm from Argentina, so IIRC the default configuration is to use semicolons instead of comas, and the decimal point is a coma. (Add that to the feature request list, but perhaps you can try to adapt to the USA market first, that is more uniform but has enough configuration options.) Sometimes I need a csv, but the the other program only understands the non-localized version of the csv, so I have to open it in a text editor and replace the semicolons with comas. I sometimes use the version of csv that use tabs instead of comas, it it probably worth adding soon. And there is an option to use many spaces to keep the data in columns. Also, there is an old post by patio11 about reading csv instead of writing them: https://www.kalzumeus.com/2015/01/28/design-and-implementation-of-csvexcel-upload-for-saas/ https://www.kalzumeus.com/2015/01/28/design-and-implementati... (HN https://news.ycombinator.com/item?id=8960280 https://news.ycombinator.com/item?id=8960280 | 107 points | Jan 28, 2015 | 35 comments) Perhaps it has something relevant.

robbiejs 6y ago
When is programming ever easy? The app uses PapaParse which is a JS lib for parsing/converting CSV to JSON and vice versa. I believe it has many settings built-in, tab-vs-comma delimiter (or somicolons), etc. (see here: https://www.papaparse.com/docs#config https://www.papaparse.com/docs#config). Right now, I am using defaults. I think I will add an "Advanced Save" option that lets the user tweak the CSV export format. Hopefully PapaParse takes care of that, best case scenario... :-) Thank you very much for your comments!