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.