If you can open it in excel, save it as a csv file.
Then upload it into the as400

Alan Shore
Programmer/Analyst, Distribution
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 10/15/2009 03:20:23 PM:

I have received a file from an outside agency that chokes
CPYFRMIMPF. The fields are pipe delimited. I have looked at the
raw file and don't see anything REALLY obvious - the file is several
hundred lines long. I can open this thing in Excel just fine, but
there is no option to save it with pipe delimiters. There is a free
text portion, which, I suspect, prompted the need to use the pipe as
a delimiter.

The agency has converted this file multiple times, and the results
are the same. Other files are just fine. When I attempted to use
an error file, I got nothing in the created member.

Is this why some of you loathe CPYFRMIMPF? Any suggestions on how
to isolate and fix the error(s) causing CPYFRMIMPF to choke? Not
sure I have the time to write the program to split this thing apart.
Can SQL be used in some way to identify or clean up the file?

John McKee
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
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.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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