Visual basic find word in a database record and pull data after it
Posted on 2004-04-06
I have a database with a MEMO field. I need a code to find a certain word in the record and if found pull the data to the right of it. if not then do nothing and go to the next record.
1 this is a test and the word is great to be alive. How are you today
2 today is friday and it is the week end
what I have here is two records.
I need it to look at the first record and find the word -----to
once found then copy the next 6 character would be:space be al
counting spaces this is how I get 6 characters
then go to the next record.
since-----to---- is not in the record do nothing. and so on until the records are all looked at.
Is this possible.
Platform = Visual Basic 6
adodb = Microsoft Access database