CSV file , to display numeric data with leading zeroes

Deepthy Jose P · New User Joined: 07 Mar 2007 Posts: 40 Location: India

I am creating a CSV file from a mainframe job, and the file contains some numeric data such as client ID which is having leading zeroes in my mainframe PS file. The same value in CSV file also should display the leading zeroes.

Bill Woodger · Posted: Fri Nov 21, 2014 1:26 pm

Well, that's excellent. Thanks for letting us know. However, this type of thing is probably better for Twitter. Leave this site free for problems that you are having, and put the daily milestones of excitement elsewhere.

enrico-sorichetti · Posted: Fri Nov 21, 2014 2:39 pm

the wording could not have been worse ...
the TS probably complains that after

having done some processing
having created a csv dataset
having transferred it to the PC
having opened it with EXCEL

what he thinks should be treated as an ALPHANUMERICS is displayed as a number
( I.E. without leading zeroes )

David Robinson · Active User Joined: 21 Dec 2011 Posts: 199 Location: UK

If Enrico's assumption as to what the TS wants is correct, then I may have the solution as I had the exact same issue myself a couple of weeks back.

But I'll wait for confirmation from the TS that this is the issue first. As Bill has pointed out, we don't actually know if he even has a problem.

Deepthy Jose P · New User Joined: 07 Mar 2007 Posts: 40 Location: India

Sorry for the confusion, My requirement is that the CSV file should convert the numeric data as Alphanumeric so that the Leading Zeroes are displayed in specific columns.

enrico-sorichetti · Posted: Fri Nov 21, 2014 4:35 pm

tbe CSV file will not convert anything ...
CSV means only Comma Separated Values

what application are You talking about ?

since we spend time trying to help You
GOOD MANNERS dictate that You should spend more of Your time in trying to post a good description of Your requirement

Deepthy Jose P · New User Joined: 07 Mar 2007 Posts: 40 Location: India

My Mainframe Job is creating a Reprot and i did a File transfer of the report as a CSV file. when i am opening the CSV file i am losing the leading zeroes in certain fields as teh cSV file is treating those fields as numeric and removing teh padded zeroes from left. I want to retain the leading zeroes in my CSV file.

expat · Posted: Fri Nov 21, 2014 5:38 pm

I would suggest that the problem is with microsoft excel or whatever you use to open the csv file with rather than a mainframe related problem.

Bill Woodger · Posted: Fri Nov 21, 2014 6:34 pm

Look at your file and confirm the leading zeros are there.

Then look at the cell formatting capabilities in Excel. Choose a non-numeric format, or a numeric format which does not suppress leading zeros.

Deepthy Jose P · New User Joined: 07 Mar 2007 Posts: 40 Location: India

Thanks Bill, the PS file created from the program had the leading zeroes. The CSV report is created on a monthly basis and so manually changing the format of the excel column to Text is not feasible. A sort step was added which will add a =" to the front and " to the end of the required columns. i.e EMP_ID column was changed to ="EMP-ID" and the CSV file generated the columns in text format retaining the leading Zeroes.

Terry Heinze · Posted: Mon Nov 24, 2014 8:19 pm