How to get number in between Range

Help Studio
, ,
1

Hi,

I have excel which has telephone numbers i have to select those numbers in website.
But in website numbers are in range how to select.

image
image1299×484 29.1 KB

New Microsoft Excel Worksheet (3).xlsx (10.7 KB)
Example excel sheet:- telephone number is “5095275720”
in website “5095275719-+5095275729”
I have to select the 5095275720

Regards
Hima

2

Hi Hima,

You can use simple regular expressions to get the number like-

System.Text.RegularExpressions.Regex.Match(strData,“[.\d]+”).Value

Let us know if you need any further details. :call_me_hand:

If you find this information useful then mark this as the solution and hit like icon.

Happy automation, Cheers!
Subhas Malik

3

So you have to extract the first part which 5095275719 and then add plus one to get 5095275720?? is this your requirement?

4

Hi Subhas,

Below are the steps Iam following.

I have excel sheet- Reading excel and storing data in DT
In website i have list box- Bot will read list list box and store the values in array
In for each row iam comparing DT row values with rray value using for each
Form DT i will get single value and i have written condition the row value matches with array value select the telephone number.
Bot is not able to select the telephone number in the ranges-5095275719-+5095275729 when ever the number is in in middle
BlankProcess13.zip (8.2 KB)

Example:- if my telephone number is some where- 5095275723

how to reslove this issue. Workflow also attached.

Regards,
Hima