topic Extract substring in QlikView

Extract substring

Mon, 13 Aug 2012 11:46:02 GMT

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!

Mon, 13 Aug 2012 11:55:27 GMT

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

Mon, 13 Aug 2012 11:56:30 GMT

once again:

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

Anonymous — Mon, 13 Aug 2012 11:58:37 GMT

This will work:

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

Just repalce the strings here with your fields or variables.

Regards,

Michael