Zero is getting truncated while XI is creating a CSV file

[Former Member]

Hi,

Scenario is IDOC to File.

in the IDOC i get some Serial number as 00000007856465 in the output CSV file i need this value as 07856465

Here when i run this map in the ESR Message mapping i could see 07856465 this value fine but while posting at the output directory the values are dropped with zeros truncated.

in the output CSV file -- the value is -- 7856465

Could you please help me out in solving this issue.

Thanks,

--Sai.

[Former Member]

Hi Sai Krishna,

As said by Bhaskar, use Formatnum function or UDF in your mapping. So that you would be able to get the 0's in the output.

I would prefer to go with FormatNum function.

Check the UDF provided by Raja Shekar in the below thread:

Thanks,

[baskar_gopalakrishnan2]

Use Formatnum standard function or UDF.

Refer this thread... very simple

[former_member854360]

Hi in receiver file adapter under message content tab please check the XML content .

Please check whether in that XML 0 prefix is present or not.

[Shabarish_Nair]

can you open the CSV file in a different editor and check if the data is still missing?

Ex. check in notepad, wordpad or excel etc

[Former Member]

HI Shabarish,

i could see the data when i open in notepad, problem with CSV.

Could you please suggest does it require any configuration in the receiver file adapter.

Thanks,

--Sai

[Shabarish_Nair]

i think it is just that excel is formatting the display. No issues with PI.

Use the format cell option and try changing the settings to general etc