Scientific to number format

You can convert scientific format number into normal number system in Data mapping.

For example:    Input :-  <Field1><![CDATA[1.2222039E7]]></Field1>
                       Output:-   <Field1>12222039</Field1>


Solution :

To do so, you need to write the following condition in textual rule of the target field.

        format-number( $Input_Schema/Root/Record/Field1,'#0.#' ) 


This will convert the scientific number "1.2222039E7" into number system "12222039"

Have more questions? Submit a request


Article is closed for comments.