Link to home
Start Free TrialLog in
Avatar of viralss
viralss

asked on

File with delimiters in VB6

Hi
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
ASKER CERTIFIED SOLUTION
Avatar of mpeaden2
mpeaden2
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of viralss
viralss

ASKER

excellent, that did the job with a little effort!