How to define a recordset when using text data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SystemShock
    New Member
    • Apr 2016
    • 1

    How to define a recordset when using text data

    Hi,

    I have looked all over and cannot get my head around the following. I hope someone here can help.

    I'm making a program in MS Visual Basic 2010 Express that will read a text data file and write the entire file to a text box. The data in said text box is then manipulated. These changes affect the entire data so I got that part done. The issue I have now is that I want to split and sort the data but need to define a recordset before doing so.

    The records in the data are variable length (lines). There are characters that distinguish the start of a record. I want to be able to add the text of a entire record to another text box and use buttons to step through the data.

    Here is a sample of what the data looks like.

    Code:
    SC000000
    SA02-Oct-2015
    SA02-Oct-2015
    SA02-Oct-2015
    SK
    SKSome text added here
    SKSome text added here
    SKSome text added here
    SKSome text added here
    SK
    SKSome text added here
    SC000001
    SA02-Oct-2015
    SA02-Oct-2015
    SK
    SKSome text added here
    SKSome text added here
    SK
    SC000002
    SA02-Oct-2015
    SA02-Oct-2015
    SK
    SKSome text added here
    SKSome text added here
    SKSome text added here
    SK
    SKSome text added here
    SKSome text added here
    SKSome text added here
    SKSome text added here
    SKSome text added here
    SK
    One can see that the start of a recordset is SC00 etc. Also note that the records, as mentioned before, are variable in the length of how many lines they contain. The data can also be in excess of 500 000 lines.

    Any suggestions/help will be greatly appreciated. I have not coded in VB since school days and allot has changed since VB6.

    Regards,

    S
Working...