Substrings in Array

innashna — Sat, 16 Nov 2024 01:02:51 GMT

Hello,

I have the array which looks like:

[2,4,5],[33,55,66].

Sometimes it looks like :

[545,345345,345435]

Meaning of values is:

value

[TYPE1, SERVICEID1, SOLUTIONID1], [TYPE2, SERVICEID2, SolutionID2]

I need to diverse this array to 6 different fields in both cases when I have either 6 fields or only 3:

Type1

ServiceID1

SolutionID1

Type2

ServiceID2

SolutionID2

Thanks,Inna

Re: Substrings in Array

rwunderlich — Mon, 16 Mar 2020 17:22:04 GMT

SubField(purgechar(myfield,'[]'), ',', 1) as Type1,
SubField(purgechar(myfield,'[]'), ',', 2) as ServiceID1,
// and so on

When the second group doesn't exist (Subfield indexes 4,5,&6) those fields will just be null in your table.