Removing employee name with certain criteria

Dear Community,

I would like to ask how can we remove the original data as below to produce the desired result.Basically i want to remove all the name within the bracket including the brackets as well.

Original Data

1. Tang Ong Ong , Ong ( Gliva)

2. Lau Lang Lang , Alica ( Lang Lang)

3. Hung Hung ( Oliver)

Desired Result

1. Tang Ong Ong , Ong

2. Lau Lang Lang , Alica

3. Hung Hung

Thank you.

Common Use Cases

Accepted answers

Elias_Nordlinder

Hello @SH_94 ,

What about something like this 🙂

You can use the RegEx_Replace function in the formula tool to get rid of the brackets and what is in there.

One formula you can use is as below
RegEx_Replace([Name],"(.*)\s\(.*","$1")

1. .* Everything before a specific space

2. \s Space

3. \( First paranthesis

4. .* Everything after paranthesis

5. $1 Replace with the first bracket

Let me know if you have any more questions or if this answer your request! 🙂

//Best Regards
Elias

Remove Employee with Criteria.yxmd

All comments

Elias_Nordlinder

Hello @SH_94 ,

What about something like this 🙂

You can use the RegEx_Replace function in the formula tool to get rid of the brackets and what is in there.

One formula you can use is as below
RegEx_Replace([Name],"(.*)\s\(.*","$1")

1. .* Everything before a specific space

2. \s Space

3. \( First paranthesis

4. .* Everything after paranthesis

5. $1 Replace with the first bracket

Let me know if you have any more questions or if this answer your request! 🙂

//Best Regards
Elias

Remove Employee with Criteria.yxmd

MarqueeCrew

@SH_94 ,

try findstring([data], " (")

it becomes(

left([data], findstring([data], " ("))

cheers,

mark

atcodedog05

Hi @SH_94,

My take on this.

Formula:

REGEX_Replace([Field1], " \(.*\)", "")

Workflow:

Replace leading space + characters in between brackets to no string.

space

\( open bracket

.* any characters

\) closed bracket

Hope this helps : )

name prep.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703