UNIX for Dummies Questions & Answers

echo $var>/root/file1.sql
sed -i 's/ /*.sql /g' file1.sql

cat file1.sql

echo $var | sed -r 's/ |$/.sql /g '

printf "%s*.sql " $var; echo

QSB*.sql SBD*.sql SDN*.sql SGJ*.sql SJP*.sql SKB*.sql SKD*.sql SLP*.sql SML*.sql SNB*.sql SRE*.sql SRG*.sql STP*.sql TAJ*.sql UMP*.sql UNO*.sql VKS*.sql VND*.sql VNS*.sql WAH*.sql ZRR*.sql

echo "$var" | sed 's/[^ ]*/&*.sql/g'

#!/bin/bash
                                                                               
var="QSB SBD SDN SGJ SJP SKB SKD SLP SML SNB SRE SRG STP TAJ UMP UNO VKS VND VNS WAH ZRR"

for v in $var; do
    echo $v"*.sql"
done

$ var="QSB SBD SDN SGJ SJP SKB SKD SLP SML SNB SRE SRG STP TAJ UMP UNO VKS VND VNS WAH ZRR"

$ awk 'gsub(/ |$/,"*.sql&")' <<<$var
QSB*.sql SBD*.sql SDN*.sql SGJ*.sql SJP*.sql SKB*.sql SKD*.sql SLP*.sql SML*.sql SNB*.sql SRE*.sql SRG*.sql STP*.sql TAJ*.sql UMP*.sql UNO*.sql VKS*.sql VND*.sql VNS*.sql WAH*.sql ZRR*.sql

#!/bin/bash --posix
var=QSB SBD SDN SGJ SJP SKB SKD SLP SML SNB SRE SRG STP TAJ UMP UNO VKS VND VNS WAH ZRR
echo "$var"

Last login: Sun Jun  1 21:21:00 on ttys000
AMIGA:barrywalker~> chmod 755 str_err.sh
AMIGA:barrywalker~> ./str_err.sh
./str_err.sh: line 2: SBD: command not found

AMIGA:barrywalker~> _

#!/bin/bash --posix
var="QSB SBD SDN SGJ SJP SKB SKD SLP SML SNB SRE SRG STP TAJ UMP UNO VKS VND VNS WAH ZRR"
var_arr=($var)
var=""
n=0
while [ $n -lt 21 ]
do
	var="$var${var_arr[$n]}"'*.sql '
	n=$((n+1))
done
echo "$var"
exit 0

Last login: Sun Jun  1 21:52:46 on ttys000
AMIGA:barrywalker~> chmod 755 str_ext.sh
AMIGA:barrywalker~> ./str_ext.sh
QSB*.sql SBD*.sql SDN*.sql SGJ*.sql SJP*.sql SKB*.sql SKD*.sql SLP*.sql SML*.sql SNB*.sql SRE*.sql SRG*.sql STP*.sql TAJ*.sql UMP*.sql UNO*.sql VKS*.sql VND*.sql VNS*.sql WAH*.sql ZRR*.sql 
AMIGA:barrywalker~> _

var_arr=($var)
printf "%s*.sql" "${var_arr[@]}"; echo

printf "%s*.sql" $var; echo