Parsing Delimited Fields Values with SQL Cross Apply

Say you wanted parse some field values:

SubscriberListMembership

UUIDLists
AAAA1|2|3|4|5|6|7
BBBB2|4|6|8|10|12|14
CCCC1|2|3

…and output something like this in Marketing Cloud:

SubscriberListMembership_Parsed

UUIDListsList1List2List3List4List5List6List7
AAAA1|2|3|4|5|6|71234567
BBBB2|4|6|8|10|12|142468101214
CCC1|2|3123

Since you can’t use any of the newer T-SQL functions for parsing in Marketing Cloud, you can use Cross Apply to determine the positions of the delimiters and then simple sub-strings to extract each one.