Hi

I am creating a CSV file , where i have fields with alphanumeric and numeric values. The numeric values with the preceding 0's are trimmed off while opening in the CSV format. Actually when the same file is opened in a TEXTPAD or NOTEPAD we could see the data correctly .

Can you please tell me whether anything can be done to avoid this scenario. ??(Still i want to open it in the CSV).

Navin

what precisely is correct?
do you want the leading zero's or don't you want them
can you try to include an example of the masterfile and the fex and the result?

Frank

Naveen,

Numerics with a L in the format will retailn leading zeroes:

P6L
I9L
D10.2L
etc..

Naveen
If you have a csv file like:

text1;text3;001234;
text2;text4;0012345;

I only know one way to retain the leading zeroes. Not perfect.

Save the file as a .txt instead of .csv. Import the file into Excel and when asked for the Data format for each column, set the numerics with leading zeroes to Text.

Otherwise try to create a macro to change the format of the cells which you want with leading zeroes to a CUstom format with 0000000, or whatever.

This is of course an Excel issue, not a WebFOCUS issue.

When you say 'see the data correctly', means all zeros you want are there. When you are opening CSV, what are you using - EXCEL, some other spreadsheet? As stated by others, it's a spreadsheet thing, not displaying leading zeros.

As said,
I understand that this is an EXCEL limitation. So we did an workaround like

Concatenating a single quote "'" before the value like

'00q

So when opening the file in CSV mode we wil be getting the data as '00q but in EXCEL we will be getting like 00q.

As of now we are ok with this.
If anyone has anyother workarounds plz do share.