Importing CSV file
Importing CSV file
I am trying to import some data from a csv file. Some of the fields have embedded commas. I have tried delimiting these fields with both inverted single commas (') and inverted double commas (") but Aware IM ignores both these delimiters and reads the embedded comma as the next field. What can I use to delimit fields with embedded commas?
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
You should enclose the data that have embedded commas into quotation mark symbols, for example:
"my data1, mydata2", "mydata3, mydata4", ...
Aware IM should be able to read data in this format.
This is also the format that most programs, such as Excel, will export the data in, when the data has embedded commas.
"my data1, mydata2", "mydata3, mydata4", ...
Aware IM should be able to read data in this format.
This is also the format that most programs, such as Excel, will export the data in, when the data has embedded commas.
Aware IM Support Team
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact: