记录几个awk命令
原始数据:
AB12 3DL,57.1189,-2.0858
AB12 3HZ,57.1018,-2.0792
AB12 3LY,57.1135,-2.0809
AB12 3QD,57.0955,-2.1006
```
1.
awk -F ',' '{print $1}' uk.csv | awk -F ' ' '{print("insert into address_uk(address) values( \"%s\" );", $1) }' > uk1.csv
```
2
grep -Eo '([A-Z]+)*' uk1.csv | awk '{print $1}' > uk2.csv
```
3
sort uk2.csv | uniq > uk3.csv
```
awk