• Loop Contents of File/Write to new file efficiencies

    We've written an automate to do a pretty simple "Loop through the contents of file", put the contents into a variable and then write to a different file contents using Mid() and a custom date function.  We're looping a 9mb file but it takes 4.5 HOURS for this thing to run.  Attached is a screen shot of most of the task.  I am wondering if there would be a more efficient way to perform this?  The reason for the Mid() is that the input file is fixed length fields that I want to write to a "not symbol" delimited file.  The special function converts a 7 digit date to an SQL Friendly one.  We then bulk load a database table with the new file.