RE: Leading 0's in a CSV file

It actually has the leading zeros in the csv file itself,  they just
don't show when I open it Excel. 

Michael Smith
iSeries.mySeries.


-----Original Message-----
From: Booth Martin [mailto:booth@xxxxxxxxxxxx] 
Sent: Friday, November 19, 2004 3:59 PM
To: Midrange Systems Technical Discussion
Subject: Re: Leading 0's in a CSV file


Have you tried %editc(yourField:'X') ? 

 

---------------------------------

Booth Martin

http://www.martinvt.com

---------------------------------

-------Original Message-------

 

From: Midrange Systems Technical Discussion

Date: 11/19/04 14:45:41

To: midrange-l@xxxxxxxxxxxx

Subject: Leading 0's in a CSV file

 

I have a database file that has a character field that contains numeric

data(part#)  example 0006075.

I have created a CSV file and this particular record looks

like"0006075", but when it is opened(through EXCEL)  it shows as 6075.

I have tried putting a single quote at the beginning of the field like

"'0006075'.  However, this shows  with the single quote.

Does anyone know how to make the leading zeros appear?

 

Michael Smith

iSeries.mySeries.

 

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx

To subscribe, unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxx

Before posting, please take a moment to review the archives

at http://archive.midrange.com/midrange-l.

 

 
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.