delemeter , ans required

[raju4u]

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 ?

[chulett]

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.

[Maveric]

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.

[ray.wurlod]

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.