Importing CSV file

Rebecca · Post by **Rebecca** » Thu Nov 10, 2005 11:42 pm

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?

aware_support · Post by **aware_support** » Fri Nov 11, 2005 1:59 am

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.

aware_support · Post by **aware_support** » Fri Nov 11, 2005 6:57 am

After doing some tests we verified that THERE IS a bug in Aware IM handling of data that contains comma symbols.

The bug will be fixed in version 1.3