Extraction of Data from Scrapped Data and storing into Excel

Hello Friends,
I have one Intex Mobile Store Locator Website which is “Store Locator”. I pass State as Maharashtra in One Dropdown and All Cities of Maharashtra from the excel sheet in another dropdown. I get Store Locator info such as Store Name, State, Address, Phone No using Data Scrapping and I store into separate Excel sheet using Write Range. Now I need City And State from Address for particular store info separately,
for example, I need Pune City for State Maharashtra and want to Store in Columns along with Store Name, State, Address and Phone number.
I need Columns such as Store Name, State, Address, City, State and Phone Number in Excel. I tired with merging DataTable and also tried using Trim function and Array on Address to get City and State separately. But sometimes for some cities, I am getting Address as output in Message Box for cities. But I need only City Name separately along with State and I need an output Excel sheet. Please suggest me a proper solution to this problem.
I am attaching Screenshot of Flow and Workflow and Excel. Please suggest to me flow as early as possible.






DemoWebsiteStoreCaptureFlow.xaml (29.9 KB)

Intex_Website_Store_Locator_Scrapping.xaml (27.7 KB)
WebMobileStoreLocatorData.xlsx (498.6 KB)

Regards
Rohit Lanjewar

Hi,

I have implemented the scraping part alone in this xaml, check with this please
ReadIntexMobile.xaml (6.8 KB)

1 Like

Hello Thanks Sarathi For your fast response. I will check the the solution and let you know.

Regards
Rohit Lanjewar

Hey Sarathi, I tried to run this xaml in UiPath Studio but I am getting error as "RemoteException wrapping UiPath.Core.SelectorNotFoundException: Cannot find the UI element corresponding to this selector: —> RemoteException wrapping System.Runtime.InteropServices.COMException: Cannot find the UI element corresponding to this selector: **
** at UiPath.UiBrowserClass.Find(String bstrSelector)

** at UiPath.Core.Browser.Find(Selector selector,**
IPlaceholderResolver placeholderResolver)
** — End of inner exception stack trace —**
** at UiPath.Core.Activities.ScopeActivity.EndExecute(NativeActivityContext context,**
IAsyncResult result)
** at UiPath.Core.Activities.AsyncNativeActivity.BookmarkResumptionCallback(NativeActivityContext context,**
Bookmark bookmark,
Object value)
** at System.Activities.Runtime.BookmarkCallbackWrapper.Invoke(NativeActivityContext context,**
Bookmark bookmark,
Object value)
** at System.Activities.Runtime.BookmarkWorkItem.Execute(ActivityExecutor executor,**
BookmarkManager bookmarkManager).
Hey can you share the Screenshot of DataScrapping of the workflow.

PFA


Regards
Rohit Lanjewar

Great article, very helpful website for users