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

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

Sending small value weight to Windchill ESI

Alex1988
13-Aquamarine

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
Casey_Swain
13-Aquamarine
(To:Alex1988)

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

 

Announcements

Top Tags