Unanswered

Remove text within parenthesis

(0) Share

Report

Posted on by RaeandKhali

I am trying to remove the text within the parenthesis as well as the parenthesis. The input is from Sharepoint "create item". In another flow, I was able to split the text, and use just what's in the parenethsis for a key column match, but now I'd like to do the opposite and be left with everything but what's in the parenthesis for my output.

Original String: Tiny Tots ELC - All Agency (CLS01803;CLS01925;CLS01807;CLS01903;CLS01928;CLS01927;CLS01842;CLS01844;CLS01902;CLS01924;CLS01859;CLS01926)

Desired String: Tiny Tots ELC - All Agency

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (1)

Report

Use split to extract the desired string. ---> trim(first(split(triggerBody()['text'],'(')))

If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.

Regards
Kaif

Was this reply helpful? Yes No
RaeandKhali 12 on at

Like (0)

Report

Sorry, I'm not sure how to do that....where would I put this: outputs('Create_item')?['body/Classroom']?

I've tried inputting this in the expression you provided and it is not working. Thanks for your help!

Was this reply helpful? Yes No
Verified answer

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (1)

Report

triggerBody()['text'] is my output from manual trigger flow --> trim(first(split(triggerBody()['text'],'('))). just replace it output in expression - trim(first(split(outputs('Create_item')?['body/Classroom'],'(')))

If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.

Regards
Kaif

Was this reply helpful? Yes No