|
Rank: Newbie
Joined: 8/3/2018 Posts: 3 Location: Singapore
|
I have a requirement from user, to convert a decimal field with filed length 9 and value as 184.00 to a string field with field length 9 and value as 000018400. I tried using format-number function for the conversion, but the end result shown as 000000184. The two zeros right after the decimal point have been truncated.
Any advice on a solution would be greatly appreciated.
|
|
Rank: Member
Joined: 6/1/2017 Posts: 10 Location: Melbourne, Australia
|
What you'll need to do is use format-number with a format of "0000000.00" then use string functions->replace to remove the decimal point. idblew attached the following image(s):
|
|
Rank: Newbie
Joined: 8/3/2018 Posts: 3 Location: Singapore
|
Thank you for the solution and advise!
|
|
guest |