.csv "" marks HELP!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ,,.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel CSV Files; Creating Of 3
.csv Commas ? 2
["\r\n" new line command in CSV file] 1
Excel And Notepad 3
Losing date format when saving .csv files 10
Save Excel file to CSV with quotation mark data delimeter? 2
Saving double-byte characters as unicode text in a CSV file 4
CSV 5

Back
Top