|
midrange.com
But unfortunately, the data is coming from the AS/400 and not being typed,
you accept the leading zeroes as a text field, (and therefore cannot
matriculate upon it).
I also have to agree with you, this thread is getting way off topic, but I
just wanted to warn the "asker" of this problem
Alan Shore
NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
Michael_Schutte@b
obevans.com
Sent by: To
rpg400-l-bounces@ RPG programming on the AS400 /
midrange.com iSeries <rpg400-l@xxxxxxxxxxxx>
cc
06/28/2006 04:40 Subject
PM RE: Getting a file to excel
Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>
Getting way off topic but if you change the cell format to TEXT first and
then type in the number, you will get what you typed.
Michael Schutte
Alan Shore
<AlanShore@xxxxxx
om> To
Sent by: RPG programming on the AS400 /
rpg400-l-bounces@ iSeries <rpg400-l@xxxxxxxxxxxx>
midrange.com cc
Subject
06/28/2006 04:37 RE: Getting a file to excel
PM
Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>
That's what I thought.
Try typing the following into an excel cell
123456789123456789
and tell me what you get.
The only way around this is by typing a single quote before you type
123456789123456789, making the cell a text format, but when we applied this
idea to our problem, the result showed leading zeroes. Even though this was
NOT incorrect, it looked weird for our users when they know that, the
particular field was a credit card.
Alan Shore
NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
<Matt.Haas@thomso
n.com>
Sent by: To
rpg400-l-bounces@ <rpg400-l@xxxxxxxxxxxx>
midrange.com cc
Subject
06/28/2006 04:25 RE: Getting a file to excel
PM
Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>
That only holds true for text files and there is a work around for it
but I don't recall what it is (searching on WEB-400 might turn it up).
For true Excel files, you can specify the data type for each cell and
it's not a problem.
Matt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Wednesday, June 28, 2006 4:02 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting a file to excel
Be careful with attempting to put data into an excel spreadsheet.
One of the problems we have (and if anyone can post an answer to this,
we
would be very grateful), is that a credit card number is held in a 19
digit
numeric field. Once this field is placed into an excel spreadsheet,
excel
will only display the first 15 numbers, 0 filling the rest - NO MATTER
what
the rest is.
I know this is a problem with excel, but, like I said, if anyone has an
answer....
Alan Shore
NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
steema@diskhaven.
com
Sent by:
To
rpg400-l-bounces@ rpg400-l@xxxxxxxxxxxx
midrange.com
cc
midrange-l@xxxxxxxxxxxx
Subject
06/28/2006 09:16 Getting a file to excel
AM
Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>
HI What are some of the methods in taking a file that was generated by
an
RPG program and getting it to the user in an Excel Worksheet file?
It seems to be a straightforward file. Is there a preferred method. Any
issues w/ v5.3 and the client access ?
Thanks,
Steve
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
