Field from CSV

[Former Member]

Hello,

I Have scenario from CSV file to RFC.

When I click in one field in CSV the field looks like "2.01E+13" (in the formula bar is look like "20100000000000")

The xi received the filed with this data "2.01E+13" I want to receive the data like "20100000000000".

Have a way to do this?

Elad

[prateek · Accepted solution]

Ideally the format of this field should be changed in the excel file before it is sent to PI.

Otherwise, you may write a UDF to extract the complete value.

Regards,

Prateek

[Former Member · Accepted solution]

Hello Prateek,

Thank you for your answer,

May you have the UDF that extract the data?

Elad

[Former Member · Accepted solution]

Hi,

Use "FormatNumber" function.

SourceFormatNumber(Number format:#)-Target field.

Regards,

Prakasu.M

[udo_martens]

Hi Elad,

check out standard function FormatNum.

[Standard Functions|http://help.sap.com/saphelp_nw2004s/helpdata/en/43/c4cdfc334824478090739c04c4a249/content.htm]

Regards,

Udo