View Single Post
 
Old 07-01-2019, 05:11 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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.
Reply With Quote