MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 2014

Re: CpytoIMPF to a CSV File



fixed

Re: Preserving leading zeros in a CSV

You didn't specifically say that you're opening the file with Excel,
but we can guess from your symptoms that's what you're doing.

The most direct answer is: No, there isn't any way to create a CSV
that preserves leading zeros using CPYTOIMPF. This is because CSVs
inherently do not store type information, and certainly not type
information that is honored by Excel. Excel aggressively tries to
interpret everything as a number if it can. And every number in Excel
is (roughly) a double-precision float, so it doesn't have enough
precision to store your "number" precisely, even after disregarding
the leading zeros.

There are kludges. If you can write a program to create the CSV, then
you have a few options at your disposal. The main thing, if you
absolutely must stick to CSV, and the file will be opened in Excel, is
to turn your data into a formula which evaluates to a string:

="00007292380143329052"

But a better option, if you can swing it, is to generate Excel files
(native Excel, either .xls or .xlsx) rather than CSVs. There are a
host of ways to do this, either with RPG or other programming
languages.

If you can't do the programming, and this is a one-time (or extremely
rare) task, then I recommend trying the import wizard, as suggested by
Matt.

John





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact