the csv file you sent me was like:
Add1,,Add2,Add3,add4,add5,Postcode
01-Oct,,LOVAT PLACE,HILLINGTON,GLASGOW,,G52 4DS
11-Dec,,LOVAT PLACE,HILLINGTON,GLASGOW,,G52 4XE
1/7A,,MONTROSE AVENUE,HILLINGTON,GLASGOW,,G52 4LA
I strongly suspect that the file you sent me was a file you'd already opened in Excel, deleted lots of rows and saved it under a new name. That file has been mangled by Excel. If you right click on the ORIGINAL csv file (you still have it don't you, before you opened it in Excel?) and choose Open with and choose NotePad, you should still see the likes of
06/04
or whatever in the addresses, remove a whole bunch of lower lines to avoid putting too much sensitive material into the public domain and to keep file size down, save it from Notepad under a new name (ending in .csv), then attach it here, zipped if necessary) so that I can experiment with it.
|