Search found 2 matches

by Rboudr2035
Tue Jul 12, 2005 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Matching columns - Using TRIM
Replies: 2
Views: 1055

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
by Rboudr2035
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

Give this a try: ICONV(input[1,6],'MX'):' ':ICONV(input[7,4],'MX'):' ':ICONV(input[11,4],'MX')