Search Results

Why not test the first line and only continue to search the log if date & time is within the last 10 minutes?

adding a line to the sample:
"InvType" "Organization" "SBC.10720101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10980101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10720101" ...

I may be misunderstanding your requirements but wouldn't:-

create a log of emails sent
match lines your "new" part of the source log to to the email log
on no hit send an email and append...

Went on this same hunt more than a year ago.
We chose to not pursue this because of it's lack of security.
The only option I came up with was using the perl module Net-SFTP-Foreign.

Why not a python or perl script using one of John Mcnamara's modules. Google search python csv to xlsx mcnamara turns up his GIT repository as the top result.

It appears that your script creates a text file with a single space as the field separator.

awk '{printf("%16.16s, %s, %s, %s\n", $1,$16,$22,$NF)}' RS="" file