Hello,
I am currently working on my first UiPath project.
- Copy the text from notepad file (each row contains a specific text),
- Go to another windows application (which is already open)
- Open a search bar in that windows application (short cut key here is “C” to open search bar)
- Paste the text in the search bar
- From the search result double click on first result
- Repeat this loop for the number of rows in notepad
Any recommendations how to do this?
Thank you in advance!
Regards,
Pankaj
Hi @Pankaj_Bawdane
First you convert your notepad.txt into excel file.xlsx then use for each row then you can take each row and do your process
here are the few steps how to convert txt to xlsx
1.First use Read Text File Activity pass the path of text file create output variable.
2.Next Use Generate Data Table Activity in properties input you can pass output variable and then create Output Data Table variable.
3.And then use Write Range Activity pass Data Table Variable.

or
- Move the text file and change the name from “file.txt” to “file.csv” .
- Read the CSV with delimiter of “TAB” .
- Write the excel back to the .xlsx file(Or any format).
Regards,
Gulshiyaa
2 Likes