cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Sending small value weight to Windchill ESI

Alex1988
12-Amethyst

Sending small value weight to Windchill ESI

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

1 REPLY 1

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

 

Top Tags