Current output:
BPR*H*36.84*D*ZZZ**ZZ*92766526
How our partner would like to see it:
BPR*H*0000000000000036.84*D*ZZZ**ZZ*92766526
------
You can achieve this by using the format number function. Use the math function Format-Number in data mapper.
Below is sample syntax in which the Salary field is formated into required format that is 0000000000.00
format-number($Input_databasetesting/DB/sb4.eb22._._dbo._testingnew_/SALARY ,"0000000000.00" )
Here $Input_databasetesting/DB/sb4.eb22._._dbo._testingnew_/SALARY is XPath of source element.
Comments
0 comments
Article is closed for comments.