Hi Friends,
I have a web page as shown below and I need to extract only numbers (1,2,3) and not other text like “+” or “T”. Then later I need to compare with a variable.
PS: With Data scrapping, its extracting all the values as datable, but I need only numbers such as 1,2,3.
Please help with your ideas and suggestion.
ppr
May 24, 2022, 10:00am
2
At least two options are available
scrapping more and filter out afterwards
regex selector pattern: \d+ for 1 or more subsequent digits
About RegEx Search A regular expression, or RegEx, is a special text string for describing a search pattern. This makes them ideally suited for searching, text processing, and data validation. Using the RegEx search capabilities in selectors enables...
Maybe you can share with us some more details on how you retrieve (approach & Selectors) the element(s)
1 Like
Hello @efleurent
Mostly you get this error when you are trying to use two different datatypes in a query…
instead of all the query you have written, you can do your task only by using the Isnumeric
method
DT.AsEnumerable().Where(Function(r) cstr(r(0)).IsNumeric ).CopyToDataTable
Use the above query and let me knwo about it
Check this workflow for better understanding
Isnumeric.xaml (7.1 KB)
EDIT:- this code will work just fine unless and until it hits a blank value from an excel file…
…
Using this it was resolved, Thank you!
system
May 27, 2022, 11:36am
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
