Extract substring

[#1]

Hi all,

from a long string i want to extract a fixed number of characters beginning at a certain string.

Example:

Original String:

thisisjustasimpleexampleofmyproblem

lets say i want to extract the first 2 characters after the string simple, which would give me 'ex'.

I want to do this in many strings. The only thing these strings have in common is the 'simple'.

How would i do this ?

Thanks a lot!

[#2]

mid(orginalstring,index(orginalstring,'simple'),2)

[#3]

once again:

mid(orginalstring,index(orginalstring,'simple')+6,2)

[Anonymous]

This will work:

=mid('thisisjustasimpleexampleofmyproblem',
index('thisisjustasimpleexampleofmyproblem','simple')+len('simple'),
2)

Just repalce the strings here with your fields or variables.

Regards,

Michael