Split with different delimiters

(0) Share

Report

Posted on by PLFMendes

I need to split a element in a array into another array, but the delimiters varies.

[

" ",

"",

"Apple,Orange,[Pineapple],GreenApple/Suggar"

]

I need the following output:

[

"Apple",

"Orange",

"Pineapple",

"GreenApple",

"Suggar"

]

The only way that I can think is to search and replace symbols like "[", "]", "/" for only one "," and then split in the standard way.
Is there a more intelligent way to do so?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
Hi @PLFMendes ,

Can you show me the orignal string and the split function you used on that string create the array:

[ " ", "", "Apple,Orange,[Pineapple],GreenApple/Suggar" ]

It may be possible to clean up the string to make it easier to extract the items later.

Ellis

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @PLFMendes,

I think the best method is to replace the symbols like "[", "/", with ",".

split(replace(replace(replace(last(outputs('Compose')),'[',''),']',''),'/',','),',')

Was this reply helpful? Yes No