Help with a "copy+paste from notepad to another windows application" in UiPath

Hello,

I am currently working on my first UiPath project.

  1. Copy the text from notepad file (each row contains a specific text),
  2. Go to another windows application (which is already open)
  3. Open a search bar in that windows application (short cut key here is “C” to open search bar)
  4. Paste the text in the search bar
  5. From the search result double click on first result
  6. 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.

image

or

  1. Move the text file and change the name from “file.txt” to “file.csv” .
  2. Read the CSV with delimiter of “TAB” .
  3. Write the excel back to the .xlsx file(Or any format).

Regards,
Gulshiyaa

2 Likes