Search Results

No surprise, data format in post #1 and post #3 are not same

Try this

awk '$1!=p{if(p)print pl; printf $0 OFS}{p=$1; pl=$2}END{print pl}' infile

What operating system and which mail version?

Also check your mail manual:
man mail

Another awk approach:
awk -v H="$HOSTNAME" -v U="$USER" 'NR%4{ORS=OFS}!(NR%4){$0=$0 OFS H OFS U;ORS=RS}1' OFS=, 1.sql
Using hostname & whoami commands instead:
awk -v H="$(hostname)" -v...

awk '{printf("%s",NR%4 ? $0",":$0",ttestsrv01,test1\n")}' 1.sql

$> cat mach*
awk '
BEGIN{
printf("%-8s%-15s%-15s%-15s%-15s\n", "Order","Item Code","Quantity","Entry Date","Ordered by")
}
...