Need Regex for below text from url

Help Studio
, , , ,
1

Hi All,

I need regex for below code and extract 5digit after $ symbol
https://inpm.work.com/xyzdmn/d/inst/1$123/1234$**47822**.htmld#TABINDEX=0&SUBTABINDEX=33

i bold the value above one i need output 47822
Thanks,
vicky

2

Hi @Vicky_K

Input= "https://inpm.work.com/xyzdmn/d/inst/1$123/1234$47822.htmld#TABINDEX=0&SUBTABINDEX=33"
Output= System.Text.RegularExpressions.Regex.Match(Input,"(?<=\$)\d+(?=\.)").Value

image
image1426×603 20.5 KB

Hope it helps!!

3

@Vicky_K

image
image1191×272 12.8 KB

System.Text.RegularExpressions.Regex.Match(Input,“(?<=$**)\d{5}”).Value

4

Hi @Vicky_K

Use the below regular expressions to extract the required output.

- Assign -> Input = "https://inpm.work.com/xyzdmn/d/inst/1$123/1234$**47822**.htmld#TABINDEX=0&SUBTABINDEX=33"
- Assign -> Output = System.Text.RegularExpressions.Regex.Match(Input,"(?<=\$\S*)\d{5}").Value

image
image1304×337 16.4 KB

Or

- Assign -> Input = "https://inpm.work.com/xyzdmn/d/inst/1$123/1234$**47822**.htmld#TABINDEX=0&SUBTABINDEX=33"
- Assign -> Output = System.Text.RegularExpressions.Regex.Match(Input,"(?<=\$\*?\*?)\d{5}").Value

image
image1432×356 19.9 KB

Hope it helps!!

5

Hi @Vicky_K

System.Text.RegularExpressions.Regex.Match(Input,"(?<=\$.*)(\d{5})(?=.*\.)").Value

image
image1104×203 12.7 KB

Happy Automation!!

6

Hi

Try this reg ex in assign activity

strval = System.Text.RegularExpressions.Regex.Match(Input,“(?<=$**)\d{5}”).ToString

Thank you

7

Hello,
Please Refer Below Screenshot

image
image1345×687 132 KB

str_data=https://inpm.work.com/xyzdmn/d/inst/1$123/1234$**47822**.htmld#TABINDEX=0&SUBTABINDEX=33

str_RequiredData=System.Text.RegularExpressions.Regex.Match(str_data,“\d{5}”).Value.ToString