Click here to Skip to main content
14,870,729 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Ex, 'x, y' in one cell. X and y will be different values for every row, that is why I cannot do "x, y" to write a comma.

What I have tried:
Updated 11-Jul-16 7:52am
Patrice T 11-Jul-16 14:32pm
Show your code, show your data, explaon the problem you have.

1 solution

CSV stands for Comma Separated Values - it means that a comma separate two values, so 1,56 will be interpreted as two values (two cells)...
As it stated in CSV definition:
6. Fields containing line breaks (CRLF), double quotes, and commas
should be enclosed in double-quotes. For example:

"aaa","b CRLF
bb","ccc" CRLF

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900