Remove content of parenthesis in a string

Like (0) Share

Report

Posted on 21 Feb 2023 03:41:21 by Kedet

Hi All,

I need help in removing the content of a parenthesis from string.

My app is pulling from a SP list and one of the column is a person picker field which is also multi-select. I am displaying the content of the person picker field in my gallery with a label(Label1) using the function: Concat(ThisItem.Employeename, Displayname, "; ")

This function concatenates the names of selected employee and separates with a semicolon.

The issue is that some employees has pronouns appended to their names. For example the value of Label1 could be: John Doe (he/him/his); Mary Kal(she/her/hers)

It can also be: John Doe (he/him/his); Bob Stone

I will like to remove the pronouns so that all names appears without the pronouns and the parenthesis. I only want the names separated with a semicolon but couldn't get that to work.

Kindly help.

Categories:

Using Apps Using Formulas

All responses (2)

Answers (2)

Verified answer

Kedet 19 on 21 Feb 2023 at 14:12:08

Like (0)

Report

Re: Remove content of parenthesis in a string

@v-liwei-msft It works perfectly, thanks so much!
Verified answer

v-liwei-msft on 21 Feb 2023 at 06:17:28

Like (0)

Report
Re: Remove content of parenthesis in a string

Hi @Kedet

Please try:

Concat(ForAll(Split(Concat(ThisItem.Employeename,DisplayName,"; "),";"),First(Split(ThisRecord.Result,"("))),Result,";")

Best Regards,

Levi