Replace a char in value of colomn

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinivenigalla
Participant
Posts: 35
Joined: Thu Aug 11, 2005 5:21 pm

Replace a char in value of colomn

Post by srinivenigalla »

I get a value in Char "00000012" but i need to replace the first character of the value with 'A'. Now the value looks like "A0000012'
What is the best way of doing it.
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

how about

Code: Select all

'A':RIGHT(In.Column,LEN(In.Column)-1)
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”