Answered

Split String

Like (0) Share

Report

Posted on 6 Oct 2023 15:07:52 by Rex2025

I have a string of text that I need to split into "pairs."

DODODODODODODODOUSUSDOUSUSDOUSUSDODOUSUSDOUSUSDODOUSUSDODODODO

So for the outcome I want:

0: DO

1: DO

and so forth....

I'm composing the variable, putting it in a string, and then using a select to break it apart. It is splitting it, but it's returning every other result in backwards order (DO = OD), and they are duplicates, meaning I'm not getting the full string broken down, just 50% of it because every entry repeats.

Select From: 
range(0, add(div(length(variables('DailyActivities')), 2), 1))

Map: 
substring(variables('DailyActivities'), mul(item(), 1), 
if(greater(add(mul(item(), 2), 2), length(variables('DailyActivities'))), 
sub(length(variables('DailyActivities')), mul(item(), 2)), 2))

Response: 
[
 "DO",
 "OD",
 "DO",
 "OD",
 "DO",
 "OD",
 "DO",
 "OD",
 "DO",
 "OD",
 "DO",
 "OD",
 "DO",
 "OD",
 "DO",
 "OU",
 "US",
 "SU",
 "US",
 "SD",
 "DO",
 "OU",
 "US",
 "SU",
 "US",
 "SD",
 "DO",
 "OU",
 "US",
 "SU",
 "US",
 ""
]

Help please!

All responses (4)

Answers (1)

Rex2025 on 06 Oct 2023 at 15:56:58

Like (1)

Report

Re: Split String

Phenomenal! Thank you so much! Chunk worked GREAT!
VictorIvanidze 12,554 on 06 Oct 2023 at 15:51:40

Like (0)

Report

Re: Split String

Use the chunk function: https://zeitgeistcode.com/power-automate-chunk-function/
Verified answer

Nived_Nambiar 17,978 Super User 2025 Season 2 on 06 Oct 2023 at 15:48:56

Like (1)

Report

Re: Split String

Hi @Rex2025

Use chunks function in power automate to split a array/string into equal length

see below

Here i am using chunk to split the string into length of each split as 2

See below result of above expression :

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Rex2025 on 06 Oct 2023 at 15:31:06

Like (0)

Report

Re: Split String

Thank you. This looks fantastic but I'll have to keep using the provided options at this time as I'm not in a position to spend any money.