Get Specific text by searching different title names in single webisite and populate this text data to column in excel to map with 'Title' that is searched

Help
1

Hi All,
I am having trouble to capture specific numeric value or text from a website which am searching with different title names and save all these texts to excel which has title data to map the data.Can any one help me to solve this.
Work flow:
Go to the website and search with the title data from excel file.
capture the specific text using text activity and I wanted to save all these to excel file to map with Titles

2

Hi @yamini_reddy

Can you provide the website and the Excel file from which you want to search on that particular site

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

3

Hi @Pratik_Wavhal Due to data security reasons i can’t share the excel and website info.It’s general search like take each value from title column in excel and search it in the website and scrape specific text.I want to save this text got from each search and save it into data table or excel

4

@yamini_reddy

Did you try with GetText Activity?

Also you can try with Get Attribute Activity, Choose the Attribute AAname

Mark as solution if this helps

Thanks

1 Like
5

Hi @yamini_reddy

You can use get Text activity for extracting some text from Website
and by using write range or write cell activity you can write those into excel

Hope this may help to solve your issue
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

6

Hi @yamini_reddy

I have created one workflow for your understanding. It will definetly help you.
GetTextByDiffTitlesFromWebsite.xaml (11.6 KB)
Add Premium Amt.xlsx (11.3 KB)

The above workflow will search for these personalities and will retrive there profession and write in to excel
image

Hope this may help to solve your issue
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like
7

Thank you Pratik.It worked for me

8

Hi @yamini_reddy

You are welcome :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

9

Hi All,in the same workflow search values should go to exact article title data.If the search values leads to multiple search results it needs to be closed and go to the next search value.can anyone help me out on this.
@Pratik_Wavhal any solution from you

10

Hi @yamini_reddy

1st of all create new post for this query.
And if you can explain a bit more der by giving some eg then it will be great to me for getting understand your problem.
Tag me in that new post.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.