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



Thanks for the idea but this is an automated nightly file transfer

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Monday, July 20, 2009 4:09 PM
To: Midrange Systems Technical Discussion
Subject: RE: Using a csv file with embedded CR/LF

If you just need a one-off, open the file with Excel and then use the
database import/export to your iSeries table.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Monday, July 20, 2009 11:08 AM
To: 'Midrange Systems Technical Discussion'
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?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-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.