IBM Mainframe Forum

Hi Team,

I am populating one field in the .csv file that is being sent to business through SMTP.

The field is of 14 bytes 10000000008250 value. When the .csv file is generated as an attachment in the email, the value looks like 1E+3.

We can achieve this by manually converting the value in .csv file into numeric with 0 decimal positions. But unfortunately client does not want to do that manual work.

We suggested to add S as prefix so that it populates as S10000000008250 but this is not expected solution.

Could you please help me with this issue ?

Regards,
Balesh GG

As we have no idea of how you are creating this data set how do you expect us to help. COBOL? PL/1? Rexx? Something else?

Hi,

I have the file created from a COBOL program and sending the file as .csv using IEBGENER.

Kindly let us know if any further information required.

Regards,
Balesh GG

it would have been nice if You had posted at least ONE record ( as created by the COBOL program )
and at least one record as it looks on the PC

IMO the problem is a poor understanding of how excel works
IIRC if a numeric value is outside the numeric bounds excel will show it in exponential form

Hi

Please find below mentioned line. This is how it looks at file level.




Regards,
Balesh GG

In other words, you're dealing with a bunch of business twits who don't know how to format numbers in Excel.

Hi,

As I mentioned earlier, the issue is with only ID_number field which is defined as numeric in COBOL program.

Please let me know if I can get some help to proceed.

Regards,
Balesh GG

Please let me know if I can get some help to proceed.

This is not an issue we can help you with. The mainframe is processing the data correctly; the file transfer is processing the data correctly; the issue is that Excel has to be told to display all the digits instead of using exponential notation; this is not an issue we can help you with -- it is user education mostly. Topic locked to prevent further waste of time.