× 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.



I say roll your own. Scott Klement's site has lots of info on reading and
writing stream files. Use those examples and write your own parsing
program. You will get exactly what you want and have much more control
over the process.

My $.02,

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi

Young i Professionals
http://www.youngiprofessionals.com



Mike Cunningham <mike.cunningham@xxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/20/2009 11:11 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Using a csv file with embedded CR/LF






I have to load a csv file I am getting from a 3rd party into an iSeries
database. The csv file files are correctly comma separated and
double-quoted but in one large text string there can be embedded carriage
return/line feeds and the same is used to end the record. The large text
string is within double quotes but CPYFRMSTMF still sees the CR/LF within
the double quotes and takes that as the end of record which results in one
record in the csv file becoming multiple records in the file that is used
in the TOMBR parameter in the CPYFRMSTMF. None of the options for
ENDLINFMT appear to work. Is there some trick to getting CPYFRMSTMF to do
what I need? I do need the embedded CR/LF characters included in the
database field so the text appears correctly when it is displayed on a web
page. Will I need to read the csv file and do my own parsing of the data
to split out each field as needed?

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.