Hi all,
I am new to using SFTP or macros and I'm not sure how to create a flow to automate the below process.
I'm trying to automate a process where I need to:
- Log in to WinSCP,
- Look for a specific folder,
- Look for the most recent Txt file posted in that folder,
- Download the Txt file.
- After the Txt file is downloaded. The txt does not have column names.
- I need to look for a document number and remove the additional data, each line starts with H and that line contains the document number, and then there are more lines starting with L. Hence I need to copy the information from the first line "H" till the last line "L" (before the new line with H).
Is there someone in this community who has faced a scenery like this one or if someone who can provide me with some ideas on how to perform a flow to complete this process?
