Originally posted by: seventieskid

When parsing XML data elements defined as xs:double in an XSD, Mercator cannot handle exponential values (e.g. 1E07). The XSD standard for xs:double does support exponential values though.

When importing the XSD schema Mercator represents the xs:double as a decimal value; no allowance is made for the exponential format.

Has this functionality been added in later releases of the type tree designer past 6.7.1 ?

Alternatively can 6.7.1 type trees be configured to handle exponential values as Number types instead of treating them as text.

Any help greatly appreciated !

#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

I came across this problem at 6.7.1 and had to write a rule to handle it. I've not seen anything in later releases to say it is handles automatically.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: seventieskid

Many thanks for the response.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: janhess

This is the rule I used.
In2 is a text item containing the exponent

=if(present(word(In2,"E",2)),
if(tonumber(word(In2,"E",2)) > 0,
tonumber(word(In2,"E",1)) * (tonumber("1" + seriestotext(clone("0",tonumber(word(In2,"E",2)))))),
tonumber(word(In2,"E",1)) / (tonumber("1" + seriestotext(clone("0",tonumber(word(In2,"E",2))))))),
tonumber(In2))
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange