How to Scrape data from terminal?


#1

Hi All,

I need your suggestion , in handling below scenario. I need to execute certain commands in terminal(similar to cmd) and scrap the data from the terminal into an excel sheet as data is following a specific pattern.

When i am trying with Data scraping, terminal is getting recognized as an image.

Kindly let me know the best way to handle this situation.

Please suggest @badita @jibanjyoti

Thanks in advance


#2

hi @ronak_94

a.Use Get text Activity

b. Use Shortcut key as Ctrl +A and Ctrl+c for sendhotkey and use copy selected text activity for pasting the value as string in result property and display the data

Thanks
Ashwin S


#3

Thank you so much for your response @AshwinS2.

I will go through the link.

As of now, can you just give me a suggestion,
My scenario is:-
for eg:-Below mentioned data is coming in terminal.



1 GARG/RONAK UXXZOA J 15APR
2 SNOW/JON UYRTRE K 15APR
3 DHONI/MS URYTRE L 15APR
and so on…

Can i get the data into excel with, Serial number, name, PNR, Segement, Date as my columns?

Looking forward to hearing from you.

Thanks in advance
Ronak Garg


#4

hi @ronak_94
yes you can use Build Datatable and add the column values in the excel and write the value in excel

Thanks
Ashwin S


#5

Thank you so much @AshwinS2.

I will go through it.

Thanks


#6

Hi @ronak_94,
Sorry for the delayed response.
Terminals are different applications and we can’t interact with them using data scraping. Try using Get Screen Area activity from Terminal Package and you can specify your columns accordingly.
image
If not satisfied with this, you can go with one by one column values as suggested by @AshwinS2.

Thanks,
Jiban


#7

Thank you so much for your response @jibanjyoti

I will go through it once.