How to strip zeros from decimal value

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
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:
Contact jwiles

Post by jwiles »

If the values are whole numbers (as in your provided examples), simply convert them to integer data types before writing them to the flat file.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
Top
VineelPrem
Participant
Posts: 19
Joined: Tue Jun 26, 2012 11:14 am
Location: Houston

Re: How to strip zeros from decimal value

Post by VineelPrem »

this function will get rid of zeroes .
DecimalToString(Input_string,"suppress_zero")
Top
Post Reply

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