How to retrieve last selected text line in text bo

garetho · May 3rd, 2005, 08:53 PM

Hi folks,

How would I achive the following. In a text box I've got a number of comma delimited records, and I want to retrieve the last record based on the first delimited item.

For example, if I've got the following rows in the text box:

  aa,123,123,123
  bb,123,123,123
  cc,123,123,123
  aa,456,456,456
  bb,456,456,456
  aa,789,789,789
  cc,456,456,456

and the row I want to retrieve is the last 'aa' row (aa,789,789,789).

Any pointers?

(BTW if it makes any difference, this is using VB.NET in the Compact Framework)

Thanks,
Gareth

garetho · May 3rd, 2005, 09:17 PM

Resolved - this did the trick:

Code:

   Private Function GetLineStartWith(ByVal txt As String) As String
        Dim arr(), ReqLine As String
        arr = Split(Me.txtStream.Text, ControlChars.CrLf)
        For i As Int32 = 0 To arr.Length - 1
            If arr(i).StartsWith(txt) Then ReqLine = arr(i)
        Next
        Return ReqLine
   End Function