Skip to Content

Error data read with 5 decimal places : tab delimited file

Hi Experts,

I have a file to jdbc scenario , the data coming from the tab delimited file is in decimals.

The issue is that the data with 0.004 is coming as 4E-03 , the way we would normally see it in excel sheet.

How do i convert this back to 0.004 ? any standard function?

Regards,

Teja

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 26, 2014 at 09:40 PM

    Hi, If you see the data in database table in incorrect format then you need to change the type of data in the database table to character.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 27, 2014 at 01:27 PM

    Hi,

    Please have a look at the discussion.

    http://scn.sap.com/thread/1888297

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2014 at 09:08 PM

    Ravi,

    Please download payloads at each step of PI pipeline (same them as .txt, please use notepad++). Please let us know, in which step you see 0.004 converted to 4E-03.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 11:12 PM

    Hi, Use standard function formatNumber in your message mapping. Enter number of zeros in format number function equal to permissible length of your target JDBC field.

    Additionally, To handle values with positive exponential values (for example 2E+07)use if else condition to check value greater than 1 and handle it accordingly.

    Best Regards,

    Amol


    pastedImage_0.png (21.2 kB)
    Add comment
    10|10000 characters needed characters exceeded