I am reading a file into VB6 which is in a very disorganised format of:
AD01 xxxxxxxx xxxxxxxxx xxxxx xxxxxxxxxxxxx AD02xxxxxxxxxxxxxx xxxxxxx xxxxxxxx AD03 xxxxxxxxxxxxxxxxxxxxxxxxx ... AD30 xxxxxxxx
where AD?? are the delimiters for pieces of data. The data may have leading white spaces, white spaces in the middle of the data, and trailing white spaces. I need to remove the leading and trailing whitespaces and replace any interim whitespaces with a single space The data in each field is of arbitrary length and can be over multiple lines.
I would like to read in the file and split up the data into managable chunks to be displayed in corresponding text boxes in the new single white space format.
as an aside if someone could tell me if it is possible to make the text boxes automatically produce a vertical scrollbar should the text be longer than the text box that would be brilliant too.
Any help or pointers would be very much appreciated.
Thanks in advance