Unanswered

Split A String Every Time a Capital Letter is Present

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (1)

Report
@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.

Was this reply helpful? Yes No
JoeHrabnicky 36 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
Verified answer

takolota1 4,974 Moderator on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Verified answer

JoeHrabnicky 36 on at

Like (1)

Report

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

Was this reply helpful? Yes No