CODEWITHSUNDEEP
uipathuipath-studio
Bala Ashokan
Bala Ashokan

Reputation: 11

Extract data from webpage to Excel

I tried to automate this portal, but since I have a trouble due to new to UiPath.

This is a URL

Have to extract CompanyName,BrokerName,Address,Phone into Excel for a number of records as per user input.

Upvotes: 0

Views: 232

Answers (1)

Kakoritz
Kakoritz

Reputation: 320

Since that client data is in one element and separated by breaks (br) I would suggest to still use the Scrape Data feature, (pick the first and second data set-group) and pull in the data set as-is; so its in block format separated by new lines. Then iterate through the results, do a split string array on the results, iterate through the string array and evaluate each line using regex. If an address match or email match or phone..etc.. Then handle it from there, You could dump the results into a temp data table and then dump the results into excel.

Granted there might need to be some fluff on your regexpressions and it might miss a few, but it would be a good start. Hope that helps get you started

Upvotes: 1

Related Questions