Live notes: postcode database

#######05/04/2016-16:51:56 GMT+1:
This is a live notes post. It is of very low interest to almost all readers, but I do believe that the more open my work is, the better that work goes. These are posts mostly written for me, but if you arrived here from a search engine and it looks like I once had a problem that you have now then feel free to drop me a line and I’ll put things into order a little bit.
#######05/04/2016-16:52:02 GMT+1:
The notes post i did about apple watch put me in mind of something I’ve always wanted – an app that could scan thought your text message history and pull out the addresses that people have sent you over the years. Given that I have the text message history I should do something about that.
#######05/04/2016-16:54:11 GMT+1:
ironically I CAN’Tuse any of the commands from the last live notes because I’m working on this while underground and the notes are online. Fail.
#######05/04/2016-16:56:21 GMT+1:
A quick check on my own postcode found some results.  Now let’s design a regular exression
[a-zA-Z]?[a-zA-Z][0-9]?[0-9]
#######05/04/2016-17:05:36 GMT+1:
Okay, this appears to be the expression I want ;
grep “[A-Z][0-9]* [0-9][A-zA-Z][a-zA-Z]” *.csv
And That give a wide variety of results.
#######06/04/2016-08:27:23 GMT+1:
I have some spare time this morning, let’s finnish up by putting this into excel.
Mac-34363b77a5de:textmessagebackup josephreddington$ grep “[A-Z][0-9]* [0-9][A-zA-Z][a-zA-Z]” *.csv > temp.csv
Mac-34363b77a5de:textmessagebackup josephreddington$ open temp.csv
#######06/04/2016-08:37:31 GMT+1:
Hmm it looks like I have to be a bit sneaky with the repalces… hang on…
#######06/04/2016-08:44:53 GMT+1:
Okay, produced and cleaned up and put into evernote.  I’m glad that there were only about 50 or so addresses, otherwise would have taken a while.

Leave a Reply