Hi,
Does anyone know how to remove the "" when you wirte data to a flat file. Help Please!!!!
ande211
Printable View
Hi,
Does anyone know how to remove the "" when you wirte data to a flat file. Help Please!!!!
ande211
You want to remove the quotation marks in the text you are writing, or the quotation marks the file puts in when you use the WRITE command?
If its the text you're writing, you can use INSTR/MID or an easy way out would be to use REPLACE which I think you can replace a character with an empty string.
Anyway, if you are trying to remove the quotes that the WRITE command puts in, use the PRINT statement instead of WRITE.
Example:
OPEN "C:\AUTOEXEC.BAT" FOR APPEND AS #1
WRITE #1, "TEST" 'That will put quotes.
PRINT #1, "TEST" 'That won't
CLOSE #1
Thai
Thai,
Thanks, I was using the Write instead of the print command.
It did the trick. Hey are you Viet? Lemme know.
Yeah I am =)
Just a note:
Without the quotes, you will not be able to retrieve data
well you CAN retrieve data, it just depends on knowing how you exported it. just line input and use the string functions to break it apart =)
Thai