delete " from a .csv file

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

Guest

I have a .csv file with a " at the start and end of the file. Anyone got a
simple function to delete these?

Bruce
 
I'm assuming you don't need this now.

If you still do, read the entire file into a variable (say, strBuffer), then
write out all but the first and last characters using Mid(strBuffer, 2,
Len(strBuffer) - 2)
 

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

csv Import into Access db 2
delete all in a csv file 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
from .asc to .excel 2
Multiple OU's in csvde 0
Problem with access acImportDelim importing csv with headers 1
Help, how do I import a CSV file when Negatives are in Parenthesis 3
import csv files to access db 2

Back
Top