Say you wanted parse some field values:
SubscriberListMembership
| UUID | Lists |
|---|---|
| AAAA | 1|2|3|4|5|6|7 |
| BBBB | 2|4|6|8|10|12|14 |
| CCCC | 1|2|3 |
…and output something like this in Marketing Cloud:
SubscriberListMembership_Parsed
| UUID | Lists | List1 | List2 | List3 | List4 | List5 | List6 | List7 |
|---|---|---|---|---|---|---|---|---|
| AAAA | 1|2|3|4|5|6|7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| BBBB | 2|4|6|8|10|12|14 | 2 | 4 | 6 | 8 | 10 | 12 | 14 |
| CCC | 1|2|3 | 1 | 2 | 3 |
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.
(Visited 1,081 times, 1 visits today)