Urgent: Fast way to read Parts of Big Files

[DraguVaso]

Hi,

I have files I need to read, which contains records with a variable lenght.
What I need to do is Copy a Part of such a File to a new File, based on the
a Begin- and End-record.

I used this functions:
Dim intMyFile As Integer = FreeFile()
FileOpen(intMyF ile, MakePathFile(st rDirS, strFileS), OpenMode.Input,
OpenAccess.Read , OpenShare.Share d, -1)
Do While Not EOF(intMyFile)
strLine = LineInput(intMy File)
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

It worked fine until I met some really big files. I have some files of 10
Mb, containing 75000 records... After 20 minutes my application still
doesn't have read the exact part.
I tryed this:
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS), FileMode.Open,
FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
intX = 0
Do While intX <= intEndRec
strLine = brFile.ReadLine
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

But it's as slow as the other one.

Only one thing was really quick (only 10 seconds):
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),
FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
Dim strChar((intEnd Rec * 128) - 1) As Char
For intX = 0 To strChar.Length - 1
strChar(intX) = " "
Next
brFile.ReadBloc k(strChar, intStartRec * 128, (intEndRec - intStartRec) *
128)

But here I had several stupid problems for which I din't really find a
solution:
- first of all: I'm having really big problems converting the Char to a
String (I tryed filing the Char with spaces and than Trim it but what about
spaces in the end of my File?)
- the ReadBlock works with character-positioning, and not with lines. Is
there a way to convert a line-position to a character-position or do a
ReadBlock with lines or something like that?
Anyhelp would really be appreciated!! I'm really stuck with this problem,
and it's kidn of urgent!! Any help regarding the ReadBlock or
StremReader-stuff, or on other (FAST!) way to do this would really be
appreciated!!

Thanks a lot in advance!!

Pieter

[CJ Taylor]

you know better than this pieter.
"DraguVaso" <pi**********@h otmail.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Hi,

I have files I need to read, which contains records with a variable lenght. What I need to do is Copy a Part of such a File to a new File, based on the a Begin- and End-record.

I used this functions:
Dim intMyFile As Integer = FreeFile()
FileOpen(intMyF ile, MakePathFile(st rDirS, strFileS), OpenMode.Input, OpenAccess.Read , OpenShare.Share d, -1)
Do While Not EOF(intMyFile)
strLine = LineInput(intMy File)
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

It worked fine until I met some really big files. I have some files of 10
Mb, containing 75000 records... After 20 minutes my application still
doesn't have read the exact part.
I tryed this:
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS), FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
intX = 0
Do While intX <= intEndRec
strLine = brFile.ReadLine
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

But it's as slow as the other one.

Only one thing was really quick (only 10 seconds):
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),
FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
Dim strChar((intEnd Rec * 128) - 1) As Char
For intX = 0 To strChar.Length - 1
strChar(intX) = " "
Next
brFile.ReadBloc k(strChar, intStartRec * 128, (intEndRec - intStartRec) *
128)

But here I had several stupid problems for which I din't really find a
solution:
- first of all: I'm having really big problems converting the Char to a
String (I tryed filing the Char with spaces and than Trim it but what about spaces in the end of my File?)
- the ReadBlock works with character-positioning, and not with lines. Is
there a way to convert a line-position to a character-position or do a
ReadBlock with lines or something like that?
Anyhelp would really be appreciated!! I'm really stuck with this problem,
and it's kidn of urgent!! Any help regarding the ReadBlock or
StremReader-stuff, or on other (FAST!) way to do this would really be
appreciated!!

Thanks a lot in advance!!

Pieter

[CJ Taylor]

you know better than this pieter.
"DraguVaso" <pi**********@h otmail.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Hi,

I have files I need to read, which contains records with a variable lenght. What I need to do is Copy a Part of such a File to a new File, based on the a Begin- and End-record.

I used this functions:
Dim intMyFile As Integer = FreeFile()
FileOpen(intMyF ile, MakePathFile(st rDirS, strFileS), OpenMode.Input, OpenAccess.Read , OpenShare.Share d, -1)
Do While Not EOF(intMyFile)
strLine = LineInput(intMy File)
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

It worked fine until I met some really big files. I have some files of 10
Mb, containing 75000 records... After 20 minutes my application still
doesn't have read the exact part.
I tryed this:
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS), FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
intX = 0
Do While intX <= intEndRec
strLine = brFile.ReadLine
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

But it's as slow as the other one.

Only one thing was really quick (only 10 seconds):
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),
FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
Dim strChar((intEnd Rec * 128) - 1) As Char
For intX = 0 To strChar.Length - 1
strChar(intX) = " "
Next
brFile.ReadBloc k(strChar, intStartRec * 128, (intEndRec - intStartRec) *
128)

But here I had several stupid problems for which I din't really find a
solution:
- first of all: I'm having really big problems converting the Char to a
String (I tryed filing the Char with spaces and than Trim it but what about spaces in the end of my File?)
- the ReadBlock works with character-positioning, and not with lines. Is
there a way to convert a line-position to a character-position or do a
ReadBlock with lines or something like that?
Anyhelp would really be appreciated!! I'm really stuck with this problem,
and it's kidn of urgent!! Any help regarding the ReadBlock or
StremReader-stuff, or on other (FAST!) way to do this would really be
appreciated!!

Thanks a lot in advance!!

Pieter

[DraguVaso]

Hihihi damn I'm affraid I don't dare to come back to this newsgroups, hihi
:-) I really made some stupid mistake :-/

That's what happens when you make love to your girlfriend during the
lunch-break, come too late back at work and skip accidently a meeting... No
wonder I didn't think clear, hahahaha :-)

Thanks guys!

And my apologizes for the 2 postings, but my Outlook Express deleted the
first message, and 30 minutes later it suddenly came back :-/

Pieter

"CJ Taylor" <no****@blowgoa ts.com> wrote in message
news:10******** *****@corp.supe rnews.com...

you know better than this pieter.
"DraguVaso" <pi**********@h otmail.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Hi,

I have files I need to read, which contains records with a variable

lenght.

What I need to do is Copy a Part of such a File to a new File, based on

the

a Begin- and End-record.

I used this functions:
Dim intMyFile As Integer = FreeFile()
FileOpen(intMyF ile, MakePathFile(st rDirS, strFileS),

OpenMode.Input,

OpenAccess.Read , OpenShare.Share d, -1)
Do While Not EOF(intMyFile)
strLine = LineInput(intMy File)
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

It worked fine until I met some really big files. I have some files of 10 Mb, containing 75000 records... After 20 minutes my application still
doesn't have read the exact part.
I tryed this:
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),

FileMode.Open,

FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
intX = 0
Do While intX <= intEndRec
strLine = brFile.ReadLine
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

But it's as slow as the other one.

Only one thing was really quick (only 10 seconds):
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),
FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
Dim strChar((intEnd Rec * 128) - 1) As Char
For intX = 0 To strChar.Length - 1
strChar(intX) = " "
Next
brFile.ReadBloc k(strChar, intStartRec * 128, (intEndRec - intStartRec) * 128)

But here I had several stupid problems for which I din't really find a
solution:
- first of all: I'm having really big problems converting the Char to a
String (I tryed filing the Char with spaces and than Trim it but what

about

spaces in the end of my File?)
- the ReadBlock works with character-positioning, and not with lines. Is
there a way to convert a line-position to a character-position or do a
ReadBlock with lines or something like that?
Anyhelp would really be appreciated!! I'm really stuck with this problem, and it's kidn of urgent!! Any help regarding the ReadBlock or
StremReader-stuff, or on other (FAST!) way to do this would really be
appreciated!!

Thanks a lot in advance!!

Pieter

[DraguVaso]

Hihihi damn I'm affraid I don't dare to come back to this newsgroups, hihi
:-) I really made some stupid mistake :-/

That's what happens when you make love to your girlfriend during the
lunch-break, come too late back at work and skip accidently a meeting... No
wonder I didn't think clear, hahahaha :-)

Thanks guys!

And my apologizes for the 2 postings, but my Outlook Express deleted the
first message, and 30 minutes later it suddenly came back :-/

Pieter

"CJ Taylor" <no****@blowgoa ts.com> wrote in message
news:10******** *****@corp.supe rnews.com...

you know better than this pieter.
"DraguVaso" <pi**********@h otmail.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Hi,

I have files I need to read, which contains records with a variable

lenght.

What I need to do is Copy a Part of such a File to a new File, based on

the

a Begin- and End-record.

I used this functions:
Dim intMyFile As Integer = FreeFile()
FileOpen(intMyF ile, MakePathFile(st rDirS, strFileS),

OpenMode.Input,

OpenAccess.Read , OpenShare.Share d, -1)
Do While Not EOF(intMyFile)
strLine = LineInput(intMy File)
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

It worked fine until I met some really big files. I have some files of 10 Mb, containing 75000 records... After 20 minutes my application still
doesn't have read the exact part.
I tryed this:
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),

FileMode.Open,

FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
intX = 0
Do While intX <= intEndRec
strLine = brFile.ReadLine
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

But it's as slow as the other one.

Only one thing was really quick (only 10 seconds):
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),
FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
Dim strChar((intEnd Rec * 128) - 1) As Char
For intX = 0 To strChar.Length - 1
strChar(intX) = " "
Next
brFile.ReadBloc k(strChar, intStartRec * 128, (intEndRec - intStartRec) * 128)

But here I had several stupid problems for which I din't really find a
solution:
- first of all: I'm having really big problems converting the Char to a
String (I tryed filing the Char with spaces and than Trim it but what

about

spaces in the end of my File?)
- the ReadBlock works with character-positioning, and not with lines. Is
there a way to convert a line-position to a character-position or do a
ReadBlock with lines or something like that?
Anyhelp would really be appreciated!! I'm really stuck with this problem, and it's kidn of urgent!! Any help regarding the ReadBlock or
StremReader-stuff, or on other (FAST!) way to do this would really be
appreciated!!

Thanks a lot in advance!!

Pieter

[CJ Taylor]

Wow.

"DraguVaso" <pi**********@h otmail.com> wrote in message
news:Ow******** *******@tk2msft ngp13.phx.gbl.. .

Hihihi damn I'm affraid I don't dare to come back to this newsgroups, hihi
:-) I really made some stupid mistake :-/

That's what happens when you make love to your girlfriend during the
lunch-break, come too late back at work and skip accidently a meeting... No wonder I didn't think clear, hahahaha :-)

Thanks guys!

And my apologizes for the 2 postings, but my Outlook Express deleted the
first message, and 30 minutes later it suddenly came back :-/

Pieter

"CJ Taylor" <no****@blowgoa ts.com> wrote in message
news:10******** *****@corp.supe rnews.com...

you know better than this pieter.
"DraguVaso" <pi**********@h otmail.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Hi,

I have files I need to read, which contains records with a variable lenght.

What I need to do is Copy a Part of such a File to a new File, based on

the

a Begin- and End-record.

I used this functions:
Dim intMyFile As Integer = FreeFile()
FileOpen(intMyF ile, MakePathFile(st rDirS, strFileS),

OpenMode.Input,

OpenAccess.Read , OpenShare.Share d, -1)
Do While Not EOF(intMyFile)
strLine = LineInput(intMy File)
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

It worked fine until I met some really big files. I have some files of 10 Mb, containing 75000 records... After 20 minutes my application still
doesn't have read the exact part.
I tryed this:
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),

FileMode.Open,

FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
intX = 0
Do While intX <= intEndRec
strLine = brFile.ReadLine
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

But it's as slow as the other one.

Only one thing was really quick (only 10 seconds):
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),
FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
Dim strChar((intEnd Rec * 128) - 1) As Char
For intX = 0 To strChar.Length - 1
strChar(intX) = " "
Next
brFile.ReadBloc k(strChar, intStartRec * 128, (intEndRec -

intStartRec) * 128)

But here I had several stupid problems for which I din't really find a
solution:
- first of all: I'm having really big problems converting the Char to

a String (I tryed filing the Char with spaces and than Trim it but what

about

spaces in the end of my File?)
- the ReadBlock works with character-positioning, and not with lines. Is there a way to convert a line-position to a character-position or do a
ReadBlock with lines or something like that?
Anyhelp would really be appreciated!! I'm really stuck with this

problem, and it's kidn of urgent!! Any help regarding the ReadBlock or
StremReader-stuff, or on other (FAST!) way to do this would really be
appreciated!!

Thanks a lot in advance!!

Pieter

[CJ Taylor]

Wow.

"DraguVaso" <pi**********@h otmail.com> wrote in message
news:Ow******** *******@tk2msft ngp13.phx.gbl.. .

Hihihi damn I'm affraid I don't dare to come back to this newsgroups, hihi
:-) I really made some stupid mistake :-/

That's what happens when you make love to your girlfriend during the
lunch-break, come too late back at work and skip accidently a meeting... No wonder I didn't think clear, hahahaha :-)

Thanks guys!

And my apologizes for the 2 postings, but my Outlook Express deleted the
first message, and 30 minutes later it suddenly came back :-/

Pieter

"CJ Taylor" <no****@blowgoa ts.com> wrote in message
news:10******** *****@corp.supe rnews.com...

you know better than this pieter.
"DraguVaso" <pi**********@h otmail.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Hi,

I have files I need to read, which contains records with a variable lenght.

What I need to do is Copy a Part of such a File to a new File, based on

the

a Begin- and End-record.

I used this functions:
Dim intMyFile As Integer = FreeFile()
FileOpen(intMyF ile, MakePathFile(st rDirS, strFileS),

OpenMode.Input,

OpenAccess.Read , OpenShare.Share d, -1)
Do While Not EOF(intMyFile)
strLine = LineInput(intMy File)
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

It worked fine until I met some really big files. I have some files of 10 Mb, containing 75000 records... After 20 minutes my application still
doesn't have read the exact part.
I tryed this:
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),

FileMode.Open,

FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
intX = 0
Do While intX <= intEndRec
strLine = brFile.ReadLine
If (intX >= intStartRec) And (intX <= intEndRec) Then
strNew = strNew & strLine & vbCrLf
End If
intX = intX + 1
Loop

But it's as slow as the other one.

Only one thing was really quick (only 10 seconds):
Dim fsFile As New FileStream(Make PathFile(strDir S, strFileS),
FileMode.Open, FileAccess.Read )
Dim brFile As New StreamReader(fs File,
System.Text.Enc oding.GetEncodi ng(1252), False, fsFile.Length - 1)
Dim strChar((intEnd Rec * 128) - 1) As Char
For intX = 0 To strChar.Length - 1
strChar(intX) = " "
Next
brFile.ReadBloc k(strChar, intStartRec * 128, (intEndRec -

intStartRec) * 128)

But here I had several stupid problems for which I din't really find a
solution:
- first of all: I'm having really big problems converting the Char to

a String (I tryed filing the Char with spaces and than Trim it but what

about

spaces in the end of my File?)
- the ReadBlock works with character-positioning, and not with lines. Is there a way to convert a line-position to a character-position or do a
ReadBlock with lines or something like that?
Anyhelp would really be appreciated!! I'm really stuck with this

problem, and it's kidn of urgent!! Any help regarding the ReadBlock or
StremReader-stuff, or on other (FAST!) way to do this would really be
appreciated!!

Thanks a lot in advance!!

Pieter