Hey guys, so I’ve ran into a problem that I can’t figure out. Is it possible to somehow define the pattern that automatically goes on in the activity “Extract Table Data”?
When I click to scrape lets say the “Prekės kodas: 0005521” it automatically pics all the data near it. What can I do?
And another question, is it possible that when I scrappe the whole box of text, it usually comes out in 3 different rows. Can I somehow put it all in one row?
@Povilas_Jonikas, Try the Get Text activity to Get all data of Text box
Hi and thanks for the response Gokul, but I’ve tried it with get text activity but it is problematic for me. When he gets the text to a variable, he doesn’t paste it to excel. He creates a new sheet, but doesn’t paste it, any ideas?
After Get text, Print it using the message box to check whether it scrap data or not
The easiest method is screen scraping and choose the Native Text…
This will give you the data…
Is it possible to provide me some sort of an example for this? I’m so confused
Hi NaNi, thanks for the response. I did it, but it still wont paste nothing to excel, any tips?
Have you checked it in the debug mode whether we’re extracting the data or not?
Looks like we’re not.
How is it possible?
Pass the Extracted Text variable to the message box and let’s See the Message is Print or not
Note:Variable type should be the string
Ok, thanks a lot! I’ll try it and let you know!
Use Output Data table activity and input is ExtrctedDataTable Output is strText
Pass this strText in the message box or AppendLine or Write text file…
Let’s see we’re able to extract and display the data in the provided output methods
Hey guys, so it looks like I just don’t get any data to the DataTable.
But I don’t understand how, it finds the pattern, but has nothing
Could you please show us the entire webpage with data wants to extract?
I basically want to extract the same data from different pages. For example:
Alfa Romeo 33 (1983- 1994) Dalys internetu, kokybiškos detalės, sparnai, arkos, slenksčiai, kėbulo dalys
BMW 3 (1990- 2000) Dalys internetu, kokybiškos detalės, sparnai, arkos, slenksčiai, kėbulo dalys
Every time it’s the same, I want to get the info which is in the same place. I tried with Extract Table data. For the first page it extracts data ant puts it in excel, but when he goes to another page, he get’s an error and shuts down.
Try like this:
From where we’re getting the URL’S?
If it is getting from Excel try like this
Build one Template DataTable and create the temp columns(Text)… output as - DtTemp
Read range - DtOut
Take one for each row in data table and pass the DtOut
Take one open browser activity and pass the URL Like this
Now use screen scraping like this
I am able to get the Output Like this
This is in studio
Take one add data row and pass the variable dt as DtTemp
Ok thanks! Ill try my best and let you know
EDIT: and yes, it is taking the website url’s from excel, and should paste it in the same excel file but different sheet
Im sorry, but why am I getting this result from scrapping that.
What should be here? I dont understand.
And is my data table correct?
Do you have any other patterns to extract from the page? Table extraction can be used to extract tables and pattern based data.