How to find specific string using regex

Help Studio
1

Hi,

I want to extract data from the below URL where I need the highlighted value, please suggest what regular expression will work here to extract the highlighted values.

image
image859×232 135 KB

2

HI @BHARAT_NAGAR

Can you send the input as text file?

Regards
Gokul

3

Hi!

try this:

System.Text.RegularExpressions.RegEx.Match("YourInputString","(https?:\/\/.\S+(?=<)|(?<=> > )\S+)(?=<)")

Reference:

Output:

Regex3
Regex3985×472 48 KB

Regards,
NaNi

4

Hi @BHARAT_NAGAR

Here is the workflow

Sequence.xaml (13.4 KB)

Hope it will resolve your query

Regards
Gokul

5

Hi
I am getting correct output but writing is not happening in excel
When I am getting data write in add data row, at that time object reference is not set (null reference exception) this error is coming how to solve it.

image

6

URL is coming in variable but writing is not happening in excel

7

Your passing a null value in the Add Data row activity

Can you share the screenshot of your workflow @BHARAT_NAGAR

8

Here is the workflow

Sequence.xaml (16.2 KB)

Hope it will works

Regards
Gokul

9

image

Final_2nd_url variable write in the add data row
in this variable, i am getting the correct value
and the same variable write in add data row

10

I ma using this step , but it is not working.
again showing same error.

11

Have you tried the above regex?

Regards,
NaNi

12

yes, its working in Regax.
Thanks all

13

can you help me in null Reference Exception.

14

Could you please show us the error where you’re getting?

Regards,
NaNi

15

Try like this:

in Add data row: ArrayRow

{Column1,Column2,1st_URL+"\in"+2nd_URL.ToString,Column4}

Regards,
NaNi

16

image
But i am write this variable in add data row

image
image848×168 32.9 KB

i am using this Regax and get the URL in two parts.

image
after that merge the URL in one variable
Ex: Final_2nd_URL(variable)
and same varible write in add data row, but it is showing the error.

17

Hi @BHARAT_NAGAR

Here is the workflow

Sequence.xaml (19.5 KB)

Hope it will works

Regards
Gokul

18

Hi
I am using same things , but its not working
it is showing the same error.

image
image789×412 96 KB

19

Hi @BHARAT_NAGAR

This workflow in working for me based on requirement of your query

Once if you share the screenshot of your Workflow will help us to look into the issue.

Regards
Gokul

20

image
In this screenshot i am get this URL using this Regax

image
image799×49 6.46 KB

image

and this part is working fine and write to excel sheet correctly.