Parse delimited string and create data sequence

[Michael A. Lowry]

If you want to create a string array from a delimited string, you can use the STR_SPLIT function. However, there is no straightforward way to creat a data sequence from a delimited string or array. (There is no PREP_PROCESS_ARRAY function.)

To work around this limitation, I created a JOBI that will create a data sequence from a delimited string.

The JOBI automatically trims leading and trailing delimiters. It does not handle blank values (two delimiters in immediate succession.) The relevant AE objects are attached.

Attachment(s)

Parse delimited string.xml   11 KB 1 version