Hi,
I am tasked with creating a workflow that will ::
1) Select text ( .txt ) files whose names are in a certain format
2) Insert a date ( from the file name ) into a specific position in row two ( between two empty commas )
3) Rewrite the edited txt file to a new directory.
A directory, which is local for now, contains .txt files whose file names have a specific format. I must use Alteryx to find those files whose names have "BB" in the 6th and 7th position of the file name.
Each file name has the date in YYYYMMDD format.
I must capture that date, insert it in between two empty commas in line 2 of the content in MMDDYYYY format.
My largest challenge at the moment is to have Alteryx look in a local directory, pick the correct .txt file, do what I've described above, then go to the next .txt file that meets the criteria mentioned. Do this until the last file has been edited and rewritten.
Any assistance with getting started would be appreciated.
Chris
