Handle %split like an array

%split is a great new feature for us, but it can be a bit tricky to handle. In order to access the second element, we need to first put the element in an array. It would be interesting if we could access the element like an array, such as in the following example:

DCL-S lDomain varchar(128) inz(*blank);

lDomain = %split('ideas.ibm.com/new-idea':'/')(1);

Result : lDomain=> 'ideas.ibm.com'

Idea priority

Medium

Post comment

Guest

Reply
| Oct 19, 2023

IBM does not intend to provide a solution to this Idea at this time, so it is being closed.

As a workaround, you can use FOR-EACH to achieve the same result.

For the simple case where you want the first value, you can code like this:

DCL-S lDomain varchar(128) inz(*blank);

FOR-EACH lDomain in %split('ideas.ibm.com/new-idea':'/');
leave;
ENDFOR;
// Result : lDomain=> 'ideas.ibm.com'

For the more complex case where you want the value N, use a counter:

DCL-S lDomain varchar(128) inz(*blank);
DCL-S counter int(10);
DCL-S n int(10);

n = 2;
counter = 0;
FOR-EACH lDomain in %split('ideas.ibm.com/new-idea':'/');
counter += 1;
if counter = n;
leave;
endif;
ENDFOR;
// Result : lDomain=> 'new-idea'

- IBM Power Systems Development

0 reply Hide replies

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use

Handle %split like an array

Please enter your email address

RELATED IDEAS

Handle %split like an array