View Single Post
  #4   Report Post  
Gordon
 
Posts: n/a
Default

acwerth wrote:
Thanks! How obvious and yet it never occured to me!!!

"Gordon" wrote:


acwerth wrote:

I am downloading data from a web based data base and it delivers the file as
a *.csv file. When I open the file on my computer, the data in each cell is
in quotations ie: 'name' 'address' etc. How do I remove these quotation marks?


Find and Replace. Find ' replace with - nothing!


If you're not used to dealing with csv files, it's not something you
would immediately think of!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk