I have a simple application, a form with two datepicker( Datepicker1 is for startsearchdate, while datepicker2 is endsearchdate) to filter out any record that not in the range. The source of the record is readed from a rtf file.The record is in format as showm below.
[dd/MM/yyyy] time result
So far i can make it run by using Startindex = RichTextBox1.find, then get the startdate charindex by using RichTextBox1.GetLineFromCharIndex(Startindex), use similiar method to get the endindex as well. Then use
RichTextBox1.Select(first, lastchar) RichTextBox1.Text = RichTextBox1.SelectedText
so text lefted behind is what I wanted. then i use readline to read every line, then use filter out the result
subStrings = Filter(arraylist2, "GOOD", True, CompareMethod.Text)
So far it works alrite, the only prolem is SPEED. With a rtf file with 60k result or lines (one result per line), It take nearly one minute to finish the task.....it is unacceptable:(
So, Is there any faster command, or ways to do this? I need this done in few second, maybe around 10s? I do search over the net before I post, but sadly that not much article regarding this(or i search the wrong keyword?)
PS: would it be faster if I put the source in textpad? or Acess database?
Any hint is welcome cos im really new in VB, not much experiece in it:)