×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How can u edit a textfile as it is being written to

How can u edit a textfile as it is being written to

How can u edit a textfile as it is being written to

(OP)
I am opening an Access Database and using recordsets, I am adding html tags to the data so as to be able to create an HTML table page. After I write the strings to the textfile, I'd like to be able to replace the (")quote marks with nothing. For example, this is what is going on.

Open "N:\directory\testfile.txt" for output as # 1

Write #1, "<html>"
Write #1, "<body>"

'start table in HTML
Write #1, "<table border=1>"

'print the header to testfile and read ColumnLabel Count
Write #1, "<th colspan =" & rstColumnLabels.RecordCount & ">" & "<font size=20>" & "<center>" & rstHeading.Fields("Heading") & "</center>" & "</font>" & "</th>"

Close #1

ANy suggestions? (p.s. I'm using VB6)
Replies continue below

Recommended for you

RE: How can u edit a textfile as it is being written to

Not sure how to do anything like this WHILE the file is being saved, but isn't there some command in VB6 that allows you to scan a file for occurrences of a certain character, or string of characters? (if so, then you could run through the file with that command (using it do find & delete occurrences of ") on the file right after it has been saved.


-Robherc
robherc@netzero.net

RE: How can u edit a textfile as it is being written to

Using the above code, you should not have any "'s in the file you are writing to. You are simply passing a string literal to the Write function so that Write #1, "This string" should look like:
This String

and not:
"This String"

RE: How can u edit a textfile as it is being written to

(OP)
Thanks for the help. I figured out that I should of been using the PRINT tag instead Of WRITE.

Jason

RE: How can u edit a textfile as it is being written to

ahhhhh... yes, I should have noticed that...

RE: How can u edit a textfile as it is being written to

Are VB6 scripts really THAT plainly spelled out???
(ie. Open "N:\directory\testfile.txt" for output as # 1)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close