Can't stop writing these stupid """"

I think my problem is that I'm trying to write a string to a text file, and VB must automatically add the "" to the front and back of any string when writing it to a text file. Is there a way to keep this from happening? I tried trimming the quotes off before writing but no luck. Maybe I'm doing something wrong.

VB Code:

Dim textfileData As String
 
Open Filename For Output As #1
    textfileData = Replace(textfileData, Chr$(34), "")
    Write #1, textfileData
Close #1

Any suggestions?

Use Print instead of Write.

Change Write to Print.

It is the write commant.. Use Print instead..

Rudy

Wow, so freaking easy. Thanks for all the replies guys. Is there a situation where you would ever choose Write over Print?

If you want the quotes! :D LOL

Quote:

---

Originally posted by Cander
If you want the quotes! :D LOL

---

Can't argue with that! :)


:D :D :D :D

Rudy

heh. Well there may be a logical reason, but I don't have a clue.

Quote:

---

Originally posted by Cander
heh. Well there may be a logical reason, but I don't have a clue.

---

The only possible reason I can come up with is that you are Appending to an existing file and want to be able to sort out what was written by the program from the origional text..

If your information is likely to have commas in it then you are better off encapsulating everything in " because otherwise anything reading your CSV file later will get confused otherwise.

I see your point but in my case my CSV is actually a semi-colonSV file. If you delimitter is anything other than a comma, it's kind of silly I think