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...

If the file is using , as the delimiter, then try FIND "" and REPLACE
with ,,.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496717