I've never writen any VB Script before and need as much help as i can get with this issue. I need a VB Script that will do the following:
- open TxtFile1.csv
-
for each line in file
-
save visit ID into array
-
close TxtFile1.csv
-
for each visit ID in array
-
search txtFile2 for match
-
if match
-
save entry into new file
Any help with this would be much appreciated!
Well, let's see. To open the file you can use the Open statement (funny, that).
Then something like a
Do Until Eof(filenumber) loop, and
Line Input #filenumber, StringVariable to read your CSV file. The
Split() function can be used to pick apart each line into fields (presumably splitting on commas).
To resize an array to make room for another entry, use
ReDim Preserve.
Is that any help in getting you started?