Split String

[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! 

[AlexEncodian]

@Rex2025 

Someone better than I will be able to fix your expressions. I do all my parsing via Regex expressions.

And I easily create Regex expressions needed using ChatGPT / Bing Chat. For this one, it told me:

----

In this regular expression:

• . matches any single character except for a newline character.
• {2} specifies that exactly two occurrences of the preceding pattern (which is . in this case) should be matched.

So, .{2} will match any two characters in a string.

----

Which I put into Encodian's Utility - Search Text (Regex) action:

And it gave me the correct result:

FYI – actions with the “Utility“ prefix only consume 1/20th of an Encodian action count . For example, a Standard plan has 500 actions so utility actions can be used 500x20 = 10,000 times. They are designed to be an incredibly cost effective productivity boost for your flow builds and there are dozens of them available.

----

*Encodian Flowr is a Standard Power Automate connector with 150+ actions to supercharge flow builds. Conversion, merging, splitting, OCRing, data extraction, QR/Bar codes, searching and much more. And we just added "Utility" actions, which are almost free to use and accelerate solution builds and remove maintenance overheads with actions like Extract text between values, extract URLs, extract email addresses, Password/GUID/HMAC creation, escaping/unescaping HTML, parsing HTML tables, etc.

[Rex2025]

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. 

[Nived_Nambiar · Accepted solution]

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! 🙌

[VictorIvanidze]

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

[Rex2025]

Phenomenal! Thank you so much! Chunk worked GREAT!