How to remove unwanted space at one column

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
fc_user
Premium Member
Premium Member
Posts: 8
Joined: Tue Feb 26, 2008 5:28 pm

Post by fc_user »

Also, once you convert it to varchar it removes the decimal. I want to retain the decimal string as it is, just without the "extra" space
Top
prasanna2883
Participant
Posts: 26
Joined: Tue Oct 23, 2007 4:07 am
Location: Blore,India

Post by prasanna2883 »

As the target is Sequentialfile, make the datatype as varchar and use StripWhiteSpace(column) , see if this would help you to remove spaces.
asdfasdf
Top
Post Reply

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