Split string to a collection

[nagestiada]

Hello guys,

I have multiple columns that has delimeter and I want it to split into a collection as a text but not sure on how to do it

Here is my DIDList

RTID	DID
1234:5123:4912	1:2:3
9243:2941:4938	1:2:3
1923	1

My local collection output should be

RTID	DID
1234	1
5123	2
4912	3
9243	1
2941	2
4938	3
1923	1

[v-bofeng-msft · Accepted solution]

Hi @nagestiada ,

I've made a test for your reference:

1\Create a DIDList

2\Split the collection by this code

Ungroup(
ForAll(
    DIDList,
    ForAll(
        Sequence(CountRows(Split(RTID,":")),1,1),
        {RTID:Last(FirstN(Split(RTID,":"),Value)).Result,DID:Last(FirstN(Split(DID,":"),Value)).Result}
    )
),"Value")

Best Regards,

Bof

[nagestiada]

@v-bofeng-msft Hello,

Sorry what if I have 3 columns instead of 2 that has the same properties but different value.