Extract specific words

Help Studio
1

Need to extract specific words from the cell in column with uipath automation

2

Hello @SureshK1

Welcome to uipath community…!

You can use Filter datatable activity to get the required data.

image
image999×581 24.6 KB

Thanks

3

@SureshK1 welcome to UiPath Community
Read cell activity can be used to get particular cell data and get the specific string using string function.what is the string you need to extract?

4

Hi @SureshK1

Welcome to Uipath community

You can try with Regex expression to achieve. Can you share the sample text here

Regards
Gokul

5

cms/1234567/abvd/4567

I want to extract only after slash which is 1234567

6

HI @SureshK1

You can try with this expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\/)\d*(?=\/)").Tostring

image

7

Input.split(“/”)(1)
You could try with this