Extract and convert strings

Hi Everyone,

How do I extract and convert a string from:
image

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

1 Like

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

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

image

1 Like

Hi @Hey_hi

Take a look at this Regex pattern:
image

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

1 Like

@Hey_hi

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

This is a great post which will help also:

Hopefully this helps you :blush:

Cheers

Steve

1 Like

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. :smile:

Glad I could help!

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

I am always happy to assist where I can :blush:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.