Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
Hi all,
We have a small issue when sending to SAP parts with small weight values. For example if you set the weight at 0.0000000001 then to SAP (in the windchill ESI Response files) the value 1.0E-12 is sent.
SAP cannot process this so we should have 0.0000000001 sent.
Any ideas?
Alex
I think you could do this by capturing the value after the "E" into a variable, and then parse the string using this as a feeder to a pad function in combination with concatenation. It would work but be a really messy formula.
Alternatively, you could parse the string into the value before "E" as a number variable, the value after "E" as a number variable, and calculate a new number variable = N1/(10*N2) and convert that back to a string.
The second approach might be easier.
Casey