Conversion of Exponential Notation to Decimal numbers

    Hi All,

     

    The below script helps in converting the Exponential Notation (or Scientific Notation) numbers to Decimal numbers

     

    Data:

    LOAD ENumber,

         Num(ENumber, '(dec)') AS Decimal

    INLINE [

    ENumber

    1.2600000000000000E-02

    1.2700000000000000E+02

    1.2800000000000000E+02

    1.2900000000000000E+02

    1.3000000000000000E+02

    1.3100000000000000E+02

    1.3200000000000000E+02

    1.3300000000000000E+02

    1.3400000000000000E+02

    1.3500000000000000E+02

    1.3600000000000000E+02

    1.3700000000000000E+02

    1.3800000000000000E+02

    1.3900000000000000E+02

    1.4000000000000000E+02

    1.4100000000000000E+02

    1.4200000000000000E+02];

     

    Output:

    ENumber Decimal
    1.2600000000000000E-020.0125999999
    1.2700000000000000E+02127
    1.2800000000000000E+02128
    1.2900000000000000E+02129
    1.3000000000000000E+02130
    1.3100000000000000E+02131
    1.3200000000000000E+02132
    1.3300000000000000E+02133
    1.3400000000000000E+02134
    1.3500000000000000E+02135
    1.3600000000000000E+02136
    1.3700000000000000E+02137
    1.3800000000000000E+02138
    1.3900000000000000E+02139
    1.4000000000000000E+02140
    1.4100000000000000E+02141
    1.4200000000000000E+02142

     

    Hope this helps you.

     

    Regards,

    jagan.