Re: Variable length array and Split

I think Jon is right - %split isn’t designed to split CSV-like data, but more for splitting „sentences“ into „words“ (tokens) for thinks like source-code interpretation or things like that.

Anyway it works exactly like described in the docs.

If you want something more CSV-like you should try the SYSTOOLS.SPLIT table function from SQL - too bad, that SQL doesn’t support dynamic arrays so far, but this TF gives you „empty“ elements.

HTH
Daniel

Von meinem iPhone gesendet

Am 11.05.2022 um 17:37 schrieb Jon Paris <jon.paris@xxxxxxxxxxxxxx>:

As I said "I wish it wasn't so but that is by design apparently."

Seems like a good prospect for an Idea (formerly RFE) to add an additional option.

I suspect that RPG's %Split is based on the C function strtok() which I have previously used in RPG to achieve what %Split does. It has the same problem.


Jon P.

On May 11, 2022, at 8:37 AM, Therrien, Paul via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Having to preprocess the array to add data between delimiters seems to remove the value of %split() function.


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon Paris
Sent: Wednesday, May 11, 2022 8:33 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Variable length array and Split

This (coding wise) is off the top of my head with no testing so ....

Variable length arrays are cleared (or set to any size) via %elem - so:

%elem(Dynarray) = 0;

Using Clear I would expect to simply set all currently active elements to their default values.

%Split is documented as ignoring consecutive delimiters. I wish it wasn't so but that is by design apparently.

Only way to make it work is to pre-process the string to insert a non-delimiter character between them.

Well I guess there are other ways as well but ...


Jon P

On May 11, 2022, at 6:50 AM, Gad Miron <gadmiron@xxxxxxxxx> wrote:

Hello sages

Having found a perfect case for splitting a string into a Variable
length array I promptly coded :

dcs-l DynArray char(20) dim(*auto:50) followed by

c clear DynArray
DynArray = %split(string : '|') ;

only to find that
a. clear does not clear a Variable length array b. %split fail to deal
with consecutive delimiters like in "first|second|third||fifth"
(it missed the missing forth element)

What am I doing wrong?

Any advice will be thankfully received.

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

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

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

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

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

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

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

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