.txt File without delimiter

BIuser · Post by **BIuser** » Thu May 31, 2007 5:26 am

How do I load a sequential file(.txt) without delimeter and ommitting the first two rows in that file

WoMaWil · Post by **WoMaWil** » Thu May 31, 2007 5:50 am

Give us a sample what you want to do and where you see the problem!

chulett · Post by **chulett** » Thu May 31, 2007 5:58 am

Does 'without delimiter' means a fixed-width file? If so, it's just a matter of a check box and getting the Display sizes correct.

You won't be able to 'omit' the first two records, but you could easily constrain your job to only handle from record 3 onward. For example...

Code: Select all

@INROWNUM > 2

satyanarayana · Post by **satyanarayana** » Thu May 31, 2007 6:00 am

Useing SequentialfileStage with Filltercommand(use Unix(HEAD or TAIL) Command to cut first two lines) and deffine single column in metadat(to read file as a single column)

DSguru2B · Post by **DSguru2B** » Thu May 31, 2007 7:33 am

head and tail commands would work on a unix box and not on a windoze box, unless MKSToolkit is installed.

DSXchange

.txt File without delimiter

.txt File without delimiter

Re: .txt File without delimiter