Error data read with 5 decimal places : tab delimited file

[former_member190239]

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

[Former Member · Accepted solution]

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.

[Former Member]

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

[RaghuVamseedhar]

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.

[Former Member]

Hi,

Please have a look at the discussion.

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