Re: Concur AP

On Sat, Dec 7, 2024 at 3:13 PM ubelhor@xxxxxxxxxxxxx
<ubelhor@xxxxxxxxxxxxx> wrote:

Thank you for responding.
I wanted to make sure to follow up.

Thanks, that's always welcome. Not just for the curiosity of those who
responded, but to contribute to the archive.

We convinced Concur to send us pipe delimited files and we will address using RPG code.

You may already know this, but recent versions of RPG have the %SPLIT
function, which can make things simpler.

Also, if you're happy with CPYFRMIMPF and are sure the delimiter will
not appear as actual data within a field, you could simply continue to
use that, specifying the FLDDLM parameter.

There are other parameters too that make the command much more
sophisticated than it was in the old days. You can even specify zero
error tolerance, or logging errors to a file (so even if it skipped
some records, you could see which ones were problematic). I suspect
you could have made the CSV work with the right combination of
parameter values. But pipe definitely makes things simpler.

John Y.