Read Text file to Create Log

I would like to be able to read the contents of a text file which is a log and copy out parts of it. The log file is created by a third party ftp program. I would like to be able to read each file that is downloaded and save it to a log file within Studio so that it can be viewed later (in orchestrator). If it fails to download or send files we plan to have an email message sent.

So I would like my log file to list files sent. It could be as basic as copying the whole line starting with “downloading” to end of file name.

Thanks.

Sample file

Size 18239084

Downloading to local file “D:\Flywire_Final_Bill\tift_daily_acct_cook_ambulatory_20210613.txt”

transferred 18239084 bytes in 25.329 seconds, 5760.785 kbps ( 720.098 kBps), transfer succeeded.

Removing remote file “/outboundextracts/tift_daily_acct_cook_ambulatory_20210613.txt”

Post Transfer Action: Deleted tift_daily_acct_cook_ambulatory_20210613.txt.

Opening remote file “/outboundextracts/tift_daily_acct_tift_ambulatory_20210613.txt” for reading

Size 28439416

Downloading to local file “D:\Flywire_Final_Bill\tift_daily_acct_tift_ambulatory_20210613.txt”

transferred 28439416 bytes in 38.831 seconds, 5859.127 kbps ( 732.391 kBps), transfer succeeded.

Removing remote file “/outboundextracts/tift_daily_acct_tift_ambulatory_20210613.txt”

Post Transfer Action: Deleted tift_daily_acct_tift_ambulatory_20210613.txt.

Hi @Josh_006

Is your requirements

  1. to be able to read the contents of the text file only ?

Or it also include
2. to be able to read the log file (optional)
Use powershell to read the log file and output to 1 or more text files for analysis.
There is also a short video explaining Powershell usage for Studio at academy.uipath.com