Re: Read CSV file from IFS -- RPG400-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: Read CSV file from IFS
From: Adam Glauser <adamglauser@xxxxxxxxxxxx>
Date: Tue, 14 Oct 2008 16:38:11 -0400
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

James Perkins wrote:

You have to read the stream file, strip out leading and trailing quotes
making sure to keep quotes within a string in tact. You also have to make
sure you don't get a comma in the middle of a string and assume that to be
delimiter.

Good point. I've been lucky enough to only have to handle CSV files without quotes.

Still, I feel that it's worth doing right once. Then you have something you can reuse, and something much more flexible than other methods mentioned earlier.

This mailing list archive is Copyright 1997-2026 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.