hi all

i need support to find a a specific data from sentence, the data have a fixed length which is 9

for example i have sentence

Code:
test 888508432199 this is test
now to take 508432199 from the sentence i should use ::::
Code:
Dim a as string 
a=mid$(text1.text,9,9)
then i will have 508432199

every thing go fine, but what if i have variable sentence

for example
Code:
this is test 888508432199
i need to change the code and her the problem

i need a function that start for example search for 888 and start to take a value after 888 for 9 character

please help me out

regards