<pre class="brush:plain;">    AB12 3DL,57.1189,-2.0858
AB12 3HZ,57.1018,-2.0792
AB12 3LY,57.1135,-2.0809
AB12 3QD,57.0955,-2.1006
```
<p>
	1.</p>
<pre class="brush:bash;">    awk -F ',' '{print $1}' uk.csv | awk -F ' ' '{print("insert into address_uk(address) values( \"%s\" );", $1) }' ＞ uk1.csv
```
<p>
	2</p>
<pre class="brush:bash;">    grep -Eo '([A-Z]+)*' uk1.csv | awk '{print $1}' ＞ uk2.csv
```
<p>
	3</p>
<pre class="brush:bash;">    sort uk2.csv | uniq ＞ uk3.csv
```