How to extract particular data for large text

Hi everyone I managed to pull off data through screen scraping from a website.

THe data came out to be like this

image

Now what I want to do is Extract the value 221250 from the first row (value can be random everytime).

Kindly suggest

@Ishan_Shelke ,
Does the Count of the number is always 6?

Then use a matches activiy and extract using regex

Yes Absolutely

There are multiple numbers with the count of 6. Howdo I exactly identify the number from line no 1

You can get the outputVariable(0).value

Hi @Ishan_Shelke

Try with this expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=min\)\s)\d+").Tostring

image

Regards
Gokul

1 Like

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