Extract and convert strings

[Hey_hi]

Hi Everyone,

How do I extract and convert a string from:

Do I have to use a substring method to extract those characters inside the brackets? ( )

[jack.chan]

@Hey_hi use this to extract text inside brackets
assuming text = “Justin (abadsa)”

System.text.regularexpressions.regex.match(text, "\((.*?)\)").groups(1).value

[Steven_McKeering]

Hi @Hey_hi

Take a look at this Regex pattern:

.NET Regex Tester - Regex Storm

Do you need assistance with writing the value into a second column? Take a look here:
UiPath: Data Tables - How to build them, add data row and output data table - YouTube

Cheers

Steve

[Steven_McKeering]

@Hey_hi

I have made a demo workflow. See orange and Red highlighted Logs below.
Main.xaml (9.8 KB)

This is a great post which will help also:

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Hopefully this helps you

Cheers

Steve

[Hey_hi]

Hi @Steven_McKeering ,

Thank you so much for the examples and guidance.

I have managed to accomplish my workflow through your methods.

Have a great day ahead!

Cheers.

[Steven_McKeering]

Glad I could help!

You can thank @AndersJensen (video) and @Palaniyappan (DataTable post) for their great tutorials and resources

I am always happy to assist where I can