Reading through a text file

[sshafe]

Let me start by defining the purpose of my script.

I am writing a VB script that will read in a text file and update a database with the information. If the first word of the line is ADD, I want to insert a row. If the first work is DELETE, I want to remove it from the database.

My question is: is it possible to read through a text file with an IF statement.

IF
ADD .....
THEN
UPDATE
ELSE IF
DELETE
THEN
REMOVE FROM DB
ELSE
ERROR MESSAGE
END IF


Thanks

 

[jonscott8]

http://msdn.microsoft.com/library/en-us/script56/html/sgWorkingWithFiles.asp

Jon Hawkins

 

[sshafe]

I've decided that I need to read the file in by character. Is there a way to do a check to determine when a tab or newline character is hit? The code I've tried comes back with syntax error

Do while Var <> Chr(09)

Help!!!