Re: Read CSV file from IFS

James,
Thanks, I did not see that parm on the CPYFRMIMPF command.
I added it and now it works the way I wanted.

 
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3
  
 





----- Original Message ----
From: James Perkins <jrperkinsjr@xxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, October 14, 2008 2:47:04 PM
Subject: Re: Read CSV file from IFS

Jeff,
Writing a customer parser is most likely a bit overkill. Try adding the
RPLNULLVAL(*FLDDFT) to the CPYFRMIMPF command. That might give you want you
are after.

James R. Perkins


On Tue, Oct 14, 2008 at 11:43 AM, Jeff Young <cooljeff913@xxxxxxxxx> wrote:

I have a text file in CSV format that I would need to load to a System
i file.
Although I can use iSeries Access file transfer, I would prefer to do
this in a program as I do not want all fields.
Some of the fields in the CSV file are NULL, so unless I change my file, I
can not use theCPYFRMIMPF command.
I am comfortable using the System API's to create files on the IFS, but
have not had to read them.
What things do I need to be aware of when reading a CSV file?
How do I tell when a field ends?
How do I tell when a record ends?
How do I test the data in the PC field for NULL?

TIA,

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
V5R2
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3
--
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.