MC Press Online Forum
Welcome, Guest
Please Login or Register.    Lost Password?
MC Press Online Forum MC Press Online Forums Application Software Microsoft
Excel not reading char fields correctly (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Excel not reading char fields correctly
#74749
Guest.Visitor (Visitor)

Birthdate:
Excel not reading char fields correctly 3 Years, 10 Months ago  
If you have a character variable that is inherently numeric and contains leading zeroes, then the leading zeroes are lost when EXCEL reads the CSV file (eg we have bank account numbers like 00000000756477438 which are text throughout every system in the bank). To not lose these, the CSV file must contain "=" before the quoted string containing the variable value.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#74748
Guest.Visitor (Visitor)

Birthdate:
Excel not reading char fields correctly 3 Years, 10 Months ago  
I have used the CPYTOIMPF to copy data from an AS400 PF file to a IFS file in Excel (csv file). But I am having a problem, I have fields defined in the AS/400 as CHAR like this: "000717" what I will see in Excel is 717 (the three zeros are ignored). These are item numbers and the leading zeros are significant. Is there any solution to this problem? <p>Thank you, <BR> This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
   MC-STORE.COM