DSXchange

Hi,
My source file have multiple delimeter.two field seprate by | (pipe) delimeter and 3rd field seprate by , (comma) delemeter.

example-
Name |Department |Date_join ,Date_birth
sachin| Accounts|2007-10-02,1982-11-04
Amit |Manager|2006-03-10,1972-12-06

please help me how can i handle in Datastage....

Regards

Deepak Sharma

The sequential stage does not allow multiple separators; but you can use a simple tr command to convert the commas into pipes.

Or declare the pipe and then 'manually' split the date field in the job.

Try using quotes for those fields tat have multiple delimiters('2007-09-08,2007-08-09')..

msc_giri - I am confused by your suggestion, could you perhaps explain how using quotes will allow these columns to be read correctly?