How handle multiple Delimeter in Datastage...

[thepakks]

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

[ArndW]

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

[chulett]

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

[mcs_giri]

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

[ArndW]

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