Question

  Asked: May 16 2008   12:58 AM GMT
  Asked by: AmandaC


CPYTOIMPF


Data mining/analysis, CPYTOIMPF, V5R3

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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataManagement and AS/400.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

AmandaC  |   May 19 2008  3:27PM GMT

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.

 

ReshmaG  |   May 21 2008  6:42AM GMT

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