Search found 61 matches
- Thu Dec 10, 2015 9:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Extracting Characters from a row
- Replies: 6
- Views: 2737
Extracting Characters from a row
Hi, I have a text file with two columns named TABLENAME and CLOB. I have to extract the information from them as follows : TABLENAME CLOB HEADER(first row) PROVIDER12082015 TRAILER(last row) 00000000669 If I have three columns in the transformer (HeadName, HeadDate, RecCount), how would I put this i...