• Loop file directory as email attachment

    I’m looping a directory for files. The directory may have 3-5 files depending on the week. I need to attach each file as an attachment to a single email. 

    how can I reference the found files as an attachment?
  • Insert changes to rows of a txt file

    I’ve got contents of a txt file that I’d like to use to write back to a SQL table, or compare against a SQL query.

    Is there a way to compare the contents of a dataset against a SQL query? Can you compare contents of two datasets like a join?

    If not, 
    Is there anyway to insert characters or a string before and after each row in the text file?

    i’ve experimented with csv to dataset and looping the dataset to write to another file, but i was trying my goal is to bypass looping dataset if possible. If the dataset could have 1000s of rows so the looping would take some time. 

    Sample from txt file row 

    Want to become 
    select all ‘1’,’0’,’2’,’usa’,’20.00’ union all
    select all ‘1’,’2’,’1’,’canada’,’10.00’ <—- no “union all” in last row