Convert Function

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
nani1974
Premium Member
Premium Member
Posts: 52
Joined: Fri Aug 31, 2007 10:59 am

Convert Function

Post by nani1974 »

Hi,
I want to convert from '-----' to '-' so for this i am using Convert function Convert('---','-',NullToValue(lnput_field,'-')) ............but i am getting empty rows in the output.........can any one please help me out with the code.

Thanks
Kumar.
Top
piyu
Participant
Posts: 52
Joined: Thu Jul 21, 2005 12:22 am
Location: Singapore

Post by piyu »

Use Trim(String,"-")

This will reduce all multiple occurrences of dashes in string to one.
Top
Post Reply

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