Page 1 of 1

.txt File without delimiter

Posted: Thu May 31, 2007 5:26 am
by BIuser
How do I load a sequential file(.txt) without delimeter and ommitting the first two rows in that file

Posted: Thu May 31, 2007 5:50 am
by WoMaWil
Give us a sample what you want to do and where you see the problem!

Posted: Thu May 31, 2007 5:58 am
by chulett
:? 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

Re: .txt File without delimiter

Posted: Thu May 31, 2007 6:00 am
by satyanarayana
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)

Posted: Thu May 31, 2007 7:33 am
by DSguru2B
head and tail commands would work on a unix box and not on a windoze box, unless MKSToolkit is installed.