How to handle multi delimiter (flat file) in DataStage ?

thirupathireddy.gankidi · Sat Aug 27, 2011 12:42 pm

a flat file contains the data..the data of the flat file having more than one delimiter..i need to load tht flat file in source... can any one give solution,,,,,,,,,,,,,,

FOR EXAMPLE:
i have text file,The file contains the data like

ord_no ord_name
1,a
2,b
3,c

in this file i used two delimeters like(comma and space)..

my prob is i need to load sequential file in to a source..

Thanks in advance
Thiru

siva.dwhbi · Post by **siva.dwhbi** » Sat Aug 27, 2011 1:05 pm

Can you bit elaborate what is that source?

suse_dk · Post by **suse_dk** » Sat Aug 27, 2011 2:22 pm

Is it only in the first line where you have the column names /header that you have a space delimiter?

chulett · Post by **chulett** » Sat Aug 27, 2011 3:47 pm

Turn on the option to skip the header record, I'm assuming you don't actually need it.

thirupathireddy.gankidi · Sat Aug 27, 2011 8:39 pm

siva.dwhbi wrote:Can you bit elaborate what is that source?

my source is a flat file..

thirupathireddy.gankidi · Sat Aug 27, 2011 8:42 pm

my source is a flat file..yah it is in the header only

chulett · Post by **chulett** » Sat Aug 27, 2011 9:15 pm

So... skip it.