Split A String Every Time a Capital Letter is Present

[JoeHrabnicky]

I'm attempting to split a string before each capital letter present in the string, but cannot identify the error in my expression that is leading me to have no success. Currently the split expression is simply returning the unsplit input as an unchanged output.

Full Flow

1. Manually triggering the flow by inputting a Feature number from Azure DevOps.

2. Getting work item details based on the input of the manual trigger.

3. Composing an object using the Title of the work item.

4. Trimming unwanted portions of the title (ex. Title is "E-Email-CompanyName-ProjectName-P2049284" and result after trim is just "ProjectName")

trim(split(outputs('Compose'),'-')[3])

5. Initializing a string variable with the output of the previous step

6. [this isn't working] Splitting the string variable before each capital letter present within the string.

split(replace(variables('ProjectNameNoSpaces'), '(?=[A-Z])', ' '), ' ')

Examples of Desired Result

Input	Desired Output
ProjectNameNoSpaces	Project Name No Spaces
ThisIsJustATest	This Is Just A Test
AaBbCcDd	Aa Bb Cc Dd

[FLMike]

Hi @JoeHrabnicky 

If the string has no spaces why do you have the replace, it seems to me your split and your replace are input backwards so your splitting on ‘ ‘ and not the regular expression you mean too and your replacing your regular expression. 


Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[takolota]

  @JoeHrabnicky 

There is no regex in Power Automate without premium / custom connectors or maybe a run script action, so this won’t work

split(replace(variables('ProjectNameNoSpaces'), '(?=[A-Z])', ' '), ' ')

Instead I suggest replacing each capital letter in the alphabet with a delimiter followed by that letter like ~A ~B ~C

That way you can then split on the ~ delimiter you added.

[JoeHrabnicky]

@takolota thanks for that info! To be fully transparent, I'm very new to writing expressions in Power Automate and ChatGPT actually wrote that one for me. Could you explain further what you mean with the use of a delimiter or provide illustration of what you mean?

[takolota · Accepted solution]

split(....replace(replace(replace(variables('ProjectNameNoSpaces'), 'A', '~A'), 'B', '~B'), 'C', '~C'), ....), '~')

So you would continue that replace pattern adding a new replace( and another set of replace parameters for each letter before doing the split on the delimiter.

[AlexEncodian · Accepted solution]

@takolota / @JoeHrabnicky / @FLMike 

One option (but uses Encodian connector) is to use Utility - Search Text (Regex) with the following regex expression:

[A-Z][a-z]*

 

This will return an array of the words which you can convert back to a string with spaces:

[JoeHrabnicky · Accepted solution]

Thanks everyone for your help! @takolota @AlexEncodian @FLMike 

I ended up going with a solution from @ekarim2020 in a different thread, which can be found here! The solution for my specific use case is his most recent post on the thread, rather than the originally marked solution.

Thanks again for all of your help though, this thread has definitely expanded my knowledge of expressions in Power Automate and will be super helpful moving forward!

Thanks,

Joe