How to get the following output using Assign Activity and String manipulation

[Ruchi (Ruchita)]

How to fetch the floowing output string using string manipulation? Kindly help

Input => 1025-MISD : Uenrkte KIFEDREWES CORP (333-22-1234)
Expected output string => 333-22-1234

[vishal.kp (vishal)]

Hi @Ruchi ,

Use the below expression:

System.Text.RegularExpressions.Regex.Match(inputString,"\((\d{3}-\d{2}-\d{4})\)").Groups(1).Value

Regards,

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

try this

System.text.RegularExpressions.Regex.Match("1025-MISD : Uenrkte KIFEDREWES CORP (333-22-1234)","(?<=\().*(?=\))").Value

Regards

[Gokul_Jayakumar (Gokul Jai)]

Hello @Ruchi
Try this Regular Expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\().+(?=\))").Tostring.trim

[Steven_McKeering]

Welcome @Ruchi to the UiPath Community

It’s great to see replies so fast on your 1st topic.

You can use Regex to achieve what you are asking.

Take a look at my Regex MegaPost to learn Regex

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…

Cheers

Steve

[Ruchi (Ruchita)]

Hi

Thank you for the solution, but I cant use regex, I have to use assign activity only

[vishal.kp (vishal)]

Hi @Ruchi ,

You can use the above mentioned expression in the assign activity, keep the string variable in the left side of the assign and the regex expression in the right side. The values will be stored in your string variable.

Regards,

[Ruchi (Ruchita)]

It worked!

Thank you so much for the help!!
Also, could you please suggest a regex generator online, where I can enter mu statement as input and get the output from the generator directly, since I am new to regex

[vishal.kp (vishal)]

@Ruchi ,

regex101: build, test, and debug regex

[Steven_McKeering]

Hey @Ruchi

Use Regex101.com to help you learn Regex and for basic patterns.

Then use .NET Regex Tester - Regex Storm for more advanced Regex patterns in the future and 100% compatibility with UiPath.

Cheers

Steve