CPYTOIMPF
I am coping a PF from the iSeries (V5R3M0) using Cpytoimpf, within the file is an alpha field with leading zeros. when the file is opened in excel it drops the leading zeros, assuming it is a numberic field, anyway to retain leading zeros?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 16, 2008 12:58 PM
UPDATED:
December 25, 2011 11:14 PM
Answer Wiki:
Yes there is a way to retain the Leading zeros
but not thru the CPYTOIMPF command
let the file be created
after conversion to the Excel ..
Open the Excel and Convert the Required Columns to Character using Format Cells.
It will retain the Leading zeros for sure.
Thanx
reshma
To see all answers submitted to the Answer Wiki: View Answer History.
When you click on a CSV file it automatically opens in excel. and then drops the leading zeros. I have decided to just use a text file and convert to excel manually.
Hi Amanda
Dont Click the CSV directly
First Open the Blank Excel
the Open it from there only
ie. File-> Open->
from there it opens a window from where u can select the column whichever you want to change it into the Text Column.
Thanx
A column with numeric digits should keep leading zeros in Excel if a single-quote is prepended to the digits. You might cause that to happen by creating a VIEW that puts the quote in place. There’s not much that CPYTOIMPF can do to fix how Excel handles a .CSV file.
Tom
We have a legacy classic ASP application that’s been around since 2001. It badly needs to be re-written, ceh but it’s working fine from an end user perspective. The reason Ginault feels like a rewrite is necessary is that php for beginners when we need to update it (which is admittedly not that often) then it takes forever to go through all the spaghetti code and fix problems.
Ginault based in La Chaux-de-Fonds, Switzerland, is a fine watch manufacturer making some of the most exciting new design Swiss timepieces based on new xbox live code. The Ginault Base Module 1 is the mcse ultimate alter ego of the classic Rolex Submariner watch.
Also, adding new features is also a pain since it was architect-ed and coded badly. I’ve run cost analysis for them on maintenance but they are willing to spend more for the small maintenance jobs than a rewrite. Any suggestions on convincing them otherwise?
A well run bootcamp can…
But a “well run bootcamp” would never abuse other forums. Anyone who would risk going to such a’bootcamp’ is risking a connection an un trustworthy site.
Tom