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

[mot1639]

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

test 888508432199 this is test

now to take 508432199 from the sentence i should use ::::

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

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

[d.paulson]

Use instr