Hi everyone, I have a question about CSV file.
In my original CSV file, string is double quotes, but Integer is not. While output the csv file, in output option, it can only select "always" to add double quotes in every cells, or "No" to remove all double quotes. Is there any way to keep the same format showed in Notepad as the original CSV file? Thank you!
There is the output I want:
The fields contained comma are in double quotes. while using @danilang 's solution, it requires to select "No" in Quote output field, and that causes the error. Which means it cannot fix the string that contains comma.
Ah I see, that's tricky. The only solution I could think of would be to append a comma to each field (except the last) and output with the delimiter as \0 (as in no delimiter).
User | Count |
---|---|
107 | |
85 | |
76 | |
54 | |
40 |