-1

I have a field which has the value say 59.0900..I want to convert it to 05909 Can somebody help me with that..Im working on datastage IBM infosphere

ramee
  • 47
  • 7

1 Answers1

-1
  • Convert the field into String
  • Trim the trailing zeros and decimal point
  • convert back to Decimal or integer
Félix Adriyel Gagnon-Grenier
  • 8,422
  • 10
  • 52
  • 65
Akila
  • 1