Txt file I/O

[pechoi]

Hi,
Is there any way to search then start reading line from search line?
For instance I have input as:
Game#1
Player1 Player2
Game#2
Player2 Player3

Search for Game#2 and start reading file from there.

THank you,

 

[Guest]

You need to normalize your data to look like this --
GAME PLAY1 PLAY2
Game#1 Player1 Player2
Game#2 Player2 Player3

GAME, PLAY1, and PLAY2 are field names in the table.

 

[Dirk Goldgar]

Hi,
Is there any way to search then start reading line from search line?
For instance I have input as:
Game#1
Player1 Player2
Game#2
Player2 Player3

Search for Game#2 and start reading file from there.

Not that I can think of. I believe you'll need to open the file, read
lines in a loop until you come to the one beginning "Game#2", and then
go on from there.

 

[Douglas J. Steele]

Not that I can think of. I believe you'll need to open the file, read
lines in a loop until you come to the one beginning "Game#2", and then
go on from there.

Depending on how big the file is, you could read the entire file into a
variable, and then manipulate the variable.


Dim intFreeFile As Integer
Dim lngFileSize As Long
Dim strBuffer As String
Dim strFileToRead As String

lngFileSize = FileLen(strFileToRead)
strBuffer = Space(lngFileSize)

intFreeFile = FreeFile
Open strFileToRead For Binary As intFreeFile
Get #intFreeFile, , strBuffer
Close intFreeFile


Don't forget that the string will now include all of the carriage
return/line feed characters now: you'll have to handle them yourself.

 

[Dirk Goldgar]

Depending on how big the file is, you could read the entire file into
a variable, and then manipulate the variable.

True, but if subsequent processing is going to be line-oriented, I think
it's easier just to read it line by line.

 

[Douglas J. Steele]

True, but if subsequent processing is going to be line-oriented, I think
it's easier just to read it line by line.

Put it in an array:

Split(strBuffer, vbCrLf)

I think it'll be faster when it's in memory than reading the file line by
line.