RE: Using CPYFRMIMPF

You can create a custom Excel macro to create the CSV file and use a
character that should not be in the data.

I use the Logical Not ¬ It kind of looks like a comma.

I have a generic version that does this for any Excel spreadsheet

You can enter any field separator you want on the prompt screen.

It also allows you to change what character to use for Alpha fields if your
data includes double quotes.

It also removes unprintable characters and Line Feeds.

I can send it to you if you wish.

All you have to do is mark the columns as A for Alpha or N for Numeric.

When you run the macro, it creates the CSV file, and then you can FTP it up
to the series I into a flat file.

CRTPF FILE(YOURLIB/SPOOL500)
RCDLEN(500)
TEXT('Flat File 500 Bytes In Length')

When you use CPYFRMIMPF, change the separator to ¬ you will be golden.

I map ¬ to my ACS keyboard for easy access.



-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
Tostaine, Jr.
Sent: Thursday, June 03, 2021 10:07 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Using CPYFRMIMPF

I've done a search replace for commas in Excel to change them to something
else, an asterisk, whatever.

Use CPYFRMIMPF, then do the same on your imported file. Quick and dirty.

On Thu, Jun 3, 2021 at 1:03 PM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Thu, Jun 3, 2021 at 11:31 AM Patrik Schindler <poc@xxxxxxxxxx> wrote:

Am 03.06.2021 um 14:48 schrieb Howie, Bill <BHowie@xxxxxxxxxxxxxxxx>:

The file started out as an XLS file that I saved as a CSV file,
and

then did the CPYFRMIMPF. Is there a foolproof way to handle the alpha
fields that have commas as part of the data?

Can't you instruct Excel to use something different as field separator?

I know CSV mostly with semi-colons as separators.

As far as I know, the only delimiter choices provided by Excel are
commas and tabs. Interestingly, even if you choose tab-delimited, it
*still* surrounds comma-containing cells with double-quotes, so that's
really no better (from OP's point of view) than Excel-generated CSV.

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com