web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Split with different d...

Power Automate

Answered

Split with different delimiters

(0) Share

Report

Report

Posted on by PLFMendes

1

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Ellis Karim 11,985 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Join the conversation