sFTP - Download files and header information using Alteryx Designer Tool called DOWNLOAD

Question

1.  Start with an  Text Input Tool .  I have called it URL and see the data

2. Bring in a tool called 'Download'

3. configure it as follows ( to get header information of files )

step 4. Connection tab ( enter USER/password)

step 5.  So far we have defined URL ( via input text)  and this download tool  will produce DownloadData and DownloadHeaders string variables

Step 6 . Split variable DownloadData into rows ( Delimiters 
) { split into rows by using tool called 'text to Columns'

Step 7. DownloadData will have Time stamp and File Name towards end

Step 8 . work on some RegEx tool  or some  other formula  commands to get the information  you want

Step 9 . How to read that file - coming soon ...

srikant96 · Accepted Answer

Tool RegEx - use this ([A-Z][a-z]{2}\s+\d{1,2}(?:\s+\d{4})?\s+\d{2}:\d{2}) to get TimeStamp ( some expert has a posting in this forum and I am just cutting and pasting a portion - Parse sFTP file listing with REGEX )

srikant96 · Accepted Answer

Here is that link - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Parse-SFTP-file-listing-with-REGEX/td-p/485870