DSXchange

Hi
i have a situation,
I have 3 coloumns
no,name,salary
1,raju,100
2,rani,10,000
3,reddy,10,00,00

The problem is ,in the thirds coloumn after 2 digits it is separated by ",",it is treated as separate coloumn ,so how we can handle this situation ?

Make sure the file gets created properly... the salary information will be valid only if quoted - "10,000" for example, or have those inner commas removed.

If you have no other way around it, then you can read the data from the file as single field and then format it into 3 columns in a transformer.

To paraphrase Craig's post, your data break the rules for a CSV file. If a data field contains delimiter characters, then that data field must be quoted.