sample csv

gistfile1.txt

"{1FB4E294-102B-475C-876A-000005E78B1E}","177000","2012-05-29 00:00","BS4 5AW","S","N","F","11","","WATER LANE","BRISLINGTON","BRISTOL","CITY OF BRISTOL","CITY OF BRISTOL","A"
"{7C2657EA-ED48-45D3-BD11-00001BB6355D}","77000","2012-07-19 00:00","L36 6BZ","S","N","F","46","","LANSBURY ROAD","","LIVERPOOL","KNOWSLEY","MERSEYSIDE","A"
"{4682268C-658F-4387-B8A1-0000425E5B57}","325000","2012-01-16 00:00","SP3 6EE","T","N","F","CAROLINE COTTAGE","","THE DENE","HINDON","SALISBURY","WILTSHIRE","WILTSHIRE","A"
"{73B95FBC-A2BF-4E7C-8B32-00004ED72404}","230000","2012-11-28 00:00","W5 4RQ","F","N","L","149","","CLAYPONDS GARDENS","","LONDON","HOUNSLOW","GREATER LONDON","A"
"{27E4A53F-58B4-45AB-B8B5-000056FA089F}","490000","2012-08-10 00:00","SK7 3DL","D","N","F","302","","BRAMHALL LANE SOUTH","BRAMHALL","STOCKPORT","STOCKPORT","GREATER MANCHESTER","A"
"{B29217D6-E577-4308-AA5C-0000811FA540}","170000","2012-08-29 00:00","IP14 2NR","D","N","F","14","","MILLERS CLOSE","","STOWMARKET","MID SUFFOLK","SUFFOLK","A"
"{ED64EF0C-E6CF-46B2-9086-000087326D9B}","235000","2012-11-14 00:00","RH4 3DL","F","N","L","GROVE COURT","6","FALKLAND GROVE","","DORKING","MOLE VALLEY","SURREY","A"
"{6D4FFEB4-E0FF-441F-BB2E-00008F6E86C6}","60000","2012-06-18 00:00","BB8 0ES","T","N","L","5","","CAMBRIDGE STREET","","COLNE","PENDLE","LANCASHIRE","A"
"{35C0C37A-87E6-4E6E-AB92-0000FBC7F69B}","186000","2012-08-30 00:00","RH19 1EX","F","Y","L","KILN HOUSE","FLAT 61","FOSTERS PLACE","","EAST GRINSTEAD","MID SUSSEX","WEST SUSSEX","A"
"{12322A19-D61F-49C8-B7F8-0000FC7C33F2}","32000","2012-01-25 00:00","B37 6DZ","F","N","L","CATESBY HOUSE","FLAT 3","KINGSHURST WAY","","BIRMINGHAM","SOLIHULL","WEST MIDLANDS","A"
"{3293DE2B-0D4D-4874-A702-000117FD6613}","329000","2012-09-17 00:00","SG4 7RE","S","N","F","2","","THE CRESCENT","ST IPPOLYTS","HITCHIN","NORTH HERTFORDSHIRE","HERTFORDSHIRE","A"
"{25177E32-0153-4DBD-9883-0001285D7AC1}","80000","2012-05-14 00:00","NE21 4EX","T","N","F","37","","TWIZELL AVENUE","","BLAYDON-ON-TYNE","GATESHEAD","TYNE AND WEAR","A"
"{5B61C2EF-8E6D-4185-8423-00013491D2C8}","180000","2012-09-28 00:00","BN7 2UX","F","N","L","PRIORY COURT","FLAT 10","MOUNTFIELD ROAD","","LEWES","LEWES","EAST SUSSEX","A"
"{30877733-F843-488F-A5E2-00013EEC7610}","250000","2012-02-09 00:00","NN10 8PJ","D","N","F","11","","BLACKWELL CLOSE","HIGHAM FERRERS","RUSHDEN","EAST NORTHAMPTONSHIRE","NORTHAMPTONSHIRE","A"
"{2A25D5DF-F22A-4B3A-B736-000141E60F63}","250000","2012-10-26 00:00","EN8 0FE","T","Y","F","52","","ALDERMERE AVENUE","CHESHUNT","WALTHAM CROSS","BROXBOURNE","HERTFORDSHIRE","A"
"{6AD37B16-F3CE-4D25-A07F-00014E22250F}","133000","2012-03-15 00:00","EX12 2TR","S","N","F","9","","WILLOW CLOSE","","SEATON","EAST DEVON","DEVON","A"
"{6F4826B4-8852-4D30-9F78-00014F8C40A4}","70000","2012-09-14 00:00","ST3 3JD","S","N","F","266","","BEACONSFIELD DRIVE","","STOKE-ON-TRENT","STOKE-ON-TRENT","STOKE-ON-TRENT","A"
"{852772E2-DDF0-4BE8-9A91-000154B3E14A}","139950","2012-11-29 00:00","ST17 4PP","S","N","F","4","","GORSLEY DALE","","STAFFORD","STAFFORD","STAFFORDSHIRE","A"
"{AF5D785A-2D80-4D3A-8FFF-00015D4718AA}","100000","2012-02-27 00:00","ST3 5TP","S","N","F","7","","EVESHAM WAY","","STOKE-ON-TRENT","STOKE-ON-TRENT","STOKE-ON-TRENT","A"
"{996DB6CD-0C42-4128-AC30-0001641CD40A}","575000","2012-06-20 00:00","DT7 3LZ","D","N","F","WEST SIDE","","CLAPPENTAIL LANE","","LYME REGIS","WEST DORSET","DORSET","A"