有趣的事

记录几个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