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
![Confused :?](./images/smilies/icon_confused.gif)
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...
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.