Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! 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