Keep value inside ()

[Robert_Wennberg]

Hello!

I am wondering if there is a way to trim and keep values inside ().
For example, I am scraping a text and getting the value “John Evans (Jonny)”, and I would like to create an assign value or similar to trim it to only keep the “Jonny” value.
Does it have to be turned into a datatable and then use Filter Datatable activity or is it an easier way of doing it?
Thanks in advance!

Best regards
Robert

[ppr (Peter Preuss)]

@Robert_Wennberg
such tasks are done with RegEx

a play with regex101.com

returns following groups:

so group2 can be trimmed.

Just to give a starter help, feel free to adopt and to enhance

[hasib08 (Motiwala Hasib)]

You can use the Split and Substring method to achieve that
Variable_name.Split(" "c)(2).Substring(1,5)

Thanks

[supermanPunch (Arpan)]

@Robert_Wennberg You can maybe use the String Split operation in this way as well :

Split(Split(“John Evans (Jonny)”,“(”)(1),“)”)(0).Trim

[Pratik_Wavhal]

Hi @Robert_Wennberg

Below regex will give the value within Bracs() everytime.

regex101: build, test, and debug regex

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[Robert_Wennberg]

@supermanPunch

Thank you for always giving easy to understand and correct solutions.
In this case, the names I get are dynamic, so by just switching out the “John Evans” part to my variable, I managed to trim the text just the way I wanted!

[Robert_Wennberg]

@ppr

Thank you for your quick and informative response.
However, I am not yet familiar with RegEx but I would like to understand more of it since it seems to be fairly used together with UiPath… Is there any place you could recommend to study it for beginners? Sorry for the inconvenience

[hasib08 (Motiwala Hasib)]

Refer this post

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

Thanks

[Robert_Wennberg]

@supermanPunch

I also have a followup question regarding the trimming. Is there a way to remove text and leave special characters such as Japanese kanji? Something like this:

Example: "Ryosuke Maeda 前田 凌佑 "
Expected result: “前田 凌佑”

The name will be dynamic.

Thanks!

[ppr (Peter Preuss)]

@Robert_Wennberg
along with the linked post from @Steven_McKeering
playing in https://regex101.com/ is a good first stop to start and grow

[Robert_Wennberg]

@ppr

Got it, thank you very much!