TextStream question

[bakerm]

Is there a way to search for a string within a textstream object without going line by line?

I have tried using instr() and I get the following err:

Invalid procedure call or argument

Thanks!!!!

 

[FRoeCassNet]

You need to read the data into a variable from the textstream. If you need to search for a string that crosses line boundaries (has an embedded newline in it), then you can use ReadAll() instead of ReadLine(). Then you can use the InStr() on that data.

Dim fso As New Scripting.FileSystemObject
Dim ts As Scripting.TextStream
Dim s As String
Dim n As Long

Set ts = fspenTextFile(<file>)
s = ts.ReadAll
n = InStr(1, s, &quot;Value&quot

 

[DrJavaJoe]

If the file isn't to big you could use File.ReadAll instead of File.ReadLine and then use the instr Function.