View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy
 
Posts: n/a
Default .csv "" marks HELP!!!

Hey chaps. Have a .csv file that has been exported from Access with the
standard delimted export spec. This file needs to be uploaded under a certain
spec.

Wherever there is a blank field, it has to read "" within .csv. Running a
find and replace does this, yet when you look in wordpad at the file, it
obviously comes through as """" due to the delimitation. How can I get the
empty fields in the .csv file to read JUST "". These fields do not have to
read "" within Excel, but obviously in the hard file, as when viewing with
notepad.

As ever, help greatly appreciated...