Forum Discussion
Noel Robles
Oct 10, 2018Copper Contributor
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" ...
John Daly
Oct 11, 2018Copper Contributor
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.