software

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 quot;quot; within .csv. Running a
find and replace does this, yet when you look in wordpad at the file, it
obviously comes through as quot;quot;quot;quot; due to the delimitation. How can I get the
empty fields in the .csv file to read JUST quot;quot;. These fields do not have to
read quot;quot; 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 quot;quot; and REPLACE
with ,,.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=496717