Forum Discussion
Help creating a correct csv/txt file.
Longstory short I have an excel xls with data looking like this:
Column A Column B
Name 123456789
I want to import it to a csv or txt file that make it look like this:
"Name","123456789"
But the main problem is that if I add a " in the name and number, for example "Name", when I convert to a txt file it shows like this
"""Name""","""123456789"""
what can I do so that it only shows one double cuotation instead of 3
Thanks
Column A Column B
Name 123456789
I want to import it to a csv or txt file that make it look like this:
"Name","123456789"
But the main problem is that if I add a " in the name and number, for example "Name", when I convert to a txt file it shows like this
"""Name""","""123456789"""
what can I do so that it only shows one double cuotation instead of 3
Thanks
1 Reply
It would seem the cells containing the data have a " at each end of the data. That would make the triple """ happen to bracket each of the ". I would try formatting the data type to text in the problem columns and leaving out any leading or trailing ". Then save as csv with comma delimited and a " for text delimiters. If you want to leave the " marks in the cells then you can save as a csv file comma delimited and no text delimiters. But when you have the " in the cell it brackets them if you use the " as text delimiters when you save the file.
