Issue with populating 14 digit numric value in .csv file



Issue with populating 14 digit numric value in .csv file

Postby Papya013 » Thu Feb 15, 2018 8:35 am

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
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Issue with populating 14 digit numric value in .csv file

Postby NicC » Thu Feb 15, 2018 4:09 pm

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?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Issue with populating 14 digit numric value in .csv file

Postby Papya013 » Thu Feb 15, 2018 4:20 pm

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
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Issue with populating 14 digit numric value in .csv file

Postby enrico-sorichetti » Thu Feb 15, 2018 4:25 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Issue with populating 14 digit numric value in .csv file

Postby Papya013 » Thu Feb 15, 2018 4:32 pm

Hi

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

Ordered_Date; Order_No    ; Order_Line_No; ID_Number    
  2018-02-09;  20914470002;             2; 10000000008250



Regards,
Balesh GG
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Issue with populating 14 digit numric value in .csv file

Postby prino » Thu Feb 15, 2018 5:24 pm

In other words, you're dealing with a bunch of business twits who don't know how to format numbers in Excel.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: Issue with populating 14 digit numric value in .csv file

Postby Papya013 » Thu Feb 15, 2018 5:47 pm

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
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Issue with populating 14 digit numric value in .csv file

Postby Robert Sample » Thu Feb 15, 2018 6:00 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to Stupid Questions

 


  • Related topics
    Replies
    Views
    Last post