DSXchange

Posted: **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

Posted: **Sat Aug 27, 2011 1:05 pm**

Can you bit elaborate what is that source?

Posted: **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?

Posted: **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.

Posted: **Sat Aug 27, 2011 8:39 pm**

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

my source is a flat file..

Posted: **Sat Aug 27, 2011 8:42 pm**

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

Posted: **Sat Aug 27, 2011 9:15 pm**

So... skip it.

DSXchange

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

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