I am working on a simple automation wherein I am extracting data from web and writing it to an excel sheet. There are two columns, one is NAME and the other is URL.
In the URL column, the data contains something like this:
I want to remove any string starting from the question mark so I’d be left with https://www.helloworld.com/123456/
The sequence looks like below.
Open Browser > Data Scraping > Excel Application Scope > ??? Cleanup data table (remove unwanted string)
How do I proceed to do that?
Thanks in advance.