Hi,
I am logging data to a historical Logging Table. At the end of the day I am pulling the data from the Log and sending it by email. The email script
works fine, and I am getting the email. But the problem is that the first record in the attached file doesn’t exist and it doesn’t matter for the
requested time period the system always put the first line. /marked bold underline bellow/
This is the email script I am using:
SENDMAIL “[email redacted]”, “”,“RFID Bags loaded for the day”, “&[$dtHT $ftT $st_h10 $et_m0 $tlA $fnDailyReport.txt]”
This is the attached file data I am receiving by Email:
“TimeInt”;“TimeStr”;“a_Prefix”;“b_Bag_Type”;“c_RFID”
1593057914;“25/06/2020 04:05:14”;2019;12;749
1593074470;“25/06/2020 08:41:10”;2019;12;2832
1593074480;“25/06/2020 08:41:20”;2019;12;749
And this is the data I have when print the Historical Log. The period is bigger than the previous file to show the first record in attached file not
exist here.
“TimeInt”;“TimeStr”;“a_Prefix”;“b_Bag_Type”;“c_RFID”
1592992385;“24/06/2020 09:53:05”;2019;12;2832
1592992395;“24/06/2020 09:53:15”;2019;12;749
1593074470;“25/06/2020 08:41:10”;2019;12;2832
1593074480;“25/06/2020 08:41:20”;2019;12;749
As you see the first record in the mail file /bold underlined/ doesn’t exist. My question is how can eliminate this fake record in the attached file?
Thank you.