Re: Quoted string in CSV data

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

Have you tried CPYFRMIMPF?

On Thu, Feb 8, 2024 at 10:00 AM Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

> I have CSV data that I need to parse.  It contains quoted values that need
> to stay together.
>
> Example CSV:
> '1234, "SMITH, JOHN", BUFFALO, NY'
>
> I need:
> 1234
> SMITH, JOHN
> BUFFALO
> NY
>
> I've tried %split() and SYSTOOLS.SPLIT, but both give the same wrong
> result.
> Code:
> %split('1234, "SMITH, JOHN", BUFFALO, NY' :',');
> select ELEMENT from table(SYSTOOLS.SPLIT('1234, "SMITH, JOHN", BUFFALO, NY'
> , ',')) as S
>
> Results:
> 1234
> "SMITH
> JOHN"
> BUFFALO
> NY
>
> Is there a way to handle this, or do I need to write my own parsing logic?
>
> TIA
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.