Extract text from a certain word to the right

[webisti]

Hello
I have a table with many rows like:
Vendor Nice Bermingham,Drawing:EDU5467 P/N 12354N
Vendor Nike London city,Drawing:EDU5467 P/N 18754N
Athletic Shoes vendor unknown<> Drawing:EDU1167 P/N 18754N

What I would need is a query to extract the rest of the words starting from Drawing.
The problem is that the mid() cannot be used since in every row the word Drawing may start in different positions.

Any ideas on how to solve this issue?



Regards


Webisti

[ranman256]

=mid([field],instr([field],"Drawing:")+8)

[webisti]

This one is more precise actually: Trim(Mid([fieldname],InStr([fieldname],"DRAW"),22)) but there I see the errors like #Func! or #Error
How can I eliminate them?

[ranman256]

Is that because THOSE records dont have the word DRAW?
AND why 22, you said the text AFTER draw. Thats 8 chars.

[June7]

Consistency is critical in string manipulation.

Is there always a colon?

Mid([fieldname], InStrRev([fieldname],":")+1)

InStr and InStrRev will error if the field is null.

Mid([fieldname], InStrRev(Nz([fieldname],""),":")+1)

Is it always the last 18 characters?

Right([fieldname],18)