Search Results

Try replacing testit_tas.sh with:
#!/bin/bash
IAm=${0##*/}
Tmpfile=/tmp/$IAm.$$

trap 'rm -f "$Tmpfile"' EXIT

./ctftestdump 10.240.56.1 8100 querytas.txt > "$Tmpfile" &
pid=$!
sleep 5
kill...

Holidays are dependent on the location. I have no idea how to generally get them.

Regarding the redirection, it seems to make sense to make them even more global, redirecting the whole for-do-done...

Please post the resulting text file so we can see what's actually in it.

The ${LINE// /<\/td><td>} is a shell "Parameter expansion - pattern substitution"

Increase efficiency.
Consider redirection in larger portions.
if [ -s file.tmp ]
then
echo "<table border=1>" > mail.txt
while read -r LINE
do
...

Once we start optimizing / improving the script, why not put everything together into one single loop:
DT=(20170811 20170831)
for i in 0 1
do echo "<table border=1>"
mysql test -e...

Welcome to the forum.

Your request has been covered umpteen times in these fora; did you bother to search? Try this as a starting point but make sure fields are separated by a <TAB> char if some...