handling fraction data

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sathishmca
Participant
Posts: 43
Joined: Mon Mar 03, 2008 10:58 pm
Location: Chennai

handling fraction data

Post by sathishmca »

Hi all,

any one help me i this.I have a data.I need to get only 2 digits after fraction point

and one more thing is i need the same if the data has 00 after fraction point.


Ex:

123.456 = 12345
123.189 = 12318
123.00 = 12300

Please help me in this.
Thanks in advance
Sathish Bhojan
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

INT(In.Column*100)
Top
Post Reply

Return to “General”