Input file
data_1 american 100
data_1 US 1000
data_1 australia 50
data_2 american 90
data_3 singapore 4
data_3 thailand 50
.
.
Desired output result
data_1 american 100
US 1000
australia 50
data_2 american 90
data_3 singapore 4
thailand 50
.
.
I only wanna print out once for those repeat info in coloumn 1.
Thanks for any command to solve it out.
kent$ echo "data_1 american 100
dquote> data_1 US 1000
dquote> data_1 australia 50
dquote> data_2 american 90
dquote> data_3 singapore 4
dquote> data_3 thailand 50"|awk '{if ($1 in a) gsub(/./," ",$1);else a[$1]=1; print $0}'
data_1 american 100
US 1000
australia 50
data_2 american 90
data_3 singapore 4
thailand 50
Data:
$ cat a2.txt
data_1 american 100
data_1 US 1000
data_1 australia 50
data_2 american 90
data_3 singapore 4
data_3 thailand 50
Script:
rm final.txt
##--get unique tags
for i in ` cat a2.txt | awk '{print $1}'|sort -u`
do
grep $i a2.txt >temp.txt
cat temp.txt | awk '{print $1}'| sort -u > temp2.txt
cat temp.txt | awk '{print $2" "$3 }'> temp3.txt
paste temp2.txt temp3.txt >> final.txt
done
cat final.txt
Output :
$ cat final.txt
data_1 american 100
US 1000
australia 50
data_2 american 90
data_3 singapore 4
thailand 50