Hi Titto
Try
Ans = Trim(input[1,Len(trim(input,' ','E'))-2],' ','E')
Not sure if the last 2 chars are in fix position (29&30) or if they could float.
Russell
Search found 2 matches
- Tue Jul 12, 2005 3:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Matching columns - Using TRIM
- Replies: 2
- Views: 1055
- Wed Feb 16, 2005 2:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hex to integer in transfrmer stage
- Replies: 10
- Views: 5321