× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. December 2014

Re: Getting a Handle on RPG’s Open Access

I don’t see why you need to do that Mike.

Remember that the in a CSV the only differentiation we normally make for character fields is to enclose them in quotes in case they contain a comma. All the data is character anyway.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Dec 23, 2014, at 9:34 AM, Smith, Mike <Mike_Smith@xxxxxxxxxxxxxxxx> wrote:

Vern,

I think I can see how I can do it now. The only thing I'm concerned with and it may not be an issue, is the amount fields.
Apparently I need to turn my file (which I guess is really just a template) in to all alpha fields, then I can load the fields with my Heading fields.

Thanks
Mike

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Tuesday, December 23, 2014 9:24 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Getting a Handle on RPG’s Open Access

Mike

I've seen CSV files with a heading row - it's just another row of comma-separated values - something like this -

"Account","Address","City","State","ZIP"
"Fred's Tire Store","123 Any Street","Los Angeles","CA",93276

Excel would open that just fine - it could care less about numeric vs alpha in the ZIP column.

Maybe you can ask the HSA folks for an example - a picture and a 1000 words comes to mind!

Good luck!
Vern

On 12/23/2014 7:36 AM, Smith, Mike wrote:
Vern,
I was thinking about that after I left for the day.
I'm creating a file for HSA contributions and the instructions said to use a .CSV file. When the requesting user opened the template file it had Headings, although it did open in Excel.
I might need to double check this and make sure it truly is a .CSV file they need.

Mike

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Vernon Hamberg
Sent: Monday, December 22, 2014 4:32 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Getting a Handle on RPG’s Open Access

Mike

CSV doesn't have a heading line as such - it's just another data line with the heading text in the fields.

I've not looked at their example in a while, so I'll take a stab at a caveat - be careful about data types if you want to put heading on it - or be sure that every column is alpha.

Vern

On 12/22/2014 3:24 PM, Smith, Mike wrote:
I’ve been working through Jon and Susans example to write a CSV file on the IFS.
I have it working, but I’m not sure how/if I can write a line with headings?

Thanks
MIke
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
--
This is the RPG programming on the IBM i (AS/400 and 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.


NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.

--
This is the RPG programming on the IBM i (AS/400 and 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.


NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
--
This is the RPG programming on the IBM i (AS/400 and 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 thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.