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