Skip to Content
0
Former Member
Jan 16, 2008 at 02:02 PM

Commas in csv file

673 Views

I have csv file which look like this

Name1,12,Address,"10,121.00",zip1

Name2,13,Address,"11,150.00",zip2

But the problem here is when xi reads it using file adapter the

amount field is taken as two parts even if i have mentioned in quotes

"10,121.00" - xi reads as "10 and 121.00"

How can i handle commas of an amount field in a csv file

Thanks

Sebin