help me in this issue MID$(text.text,*,*1)

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

Use instr