topic Help with Mid/Index function in QlikView

Help with Mid/Index function

Thu, 02 Sep 2010 13:46:47 GMT

Hi,

I'm struggling with an expression in which I want to trim and only bring in certain text from a field.

For example, I have : The Dog Walked into the room. I only want to bring in 'Walked into the room'

Any help would be appreciated!

Thanks.

SV:Help with Mid/Index function

gandalfgray — Thu, 02 Sep 2010 13:52:09 GMT

I think you need to better specify for us what you want to do.

For your specified example you could use:

Right(text,20)

SV:Help with Mid/Index function

Thu, 02 Sep 2010 15:10:33 GMT

Basically, I'd like to return all the text to the right of the end of 'The Dog '

So, if the text is 'The Dog jumped into the pool', I always want to return all text to the right of 'The Dog '. ie. 'jumped into the pool'

I hope this is more clear.

Thanks

SV:Help with Mid/Index function

nicolett_yuri — Thu, 02 Sep 2010 15:16:05 GMT

Example:

LOAD * INLINE [

The Dog jumped into the pool

The Dog Walked into the room

];

subfield(F1,'The Dog',-1)

SV:Help with Mid/Index function

Thu, 02 Sep 2010 15:16:55 GMT

I think something like this!!!!!

RIGHT('The Dog jumped into the pool' , index( 'The Dog jumped into the pool', 'The Dog' ) + len(The Dog))

SV:Help with Mid/Index function

Thu, 02 Sep 2010 15:19:47 GMT

index( 'The Dog jumped into the pool', 'The Dog' ) - First you find the start position....

Len('The Dog') - Second you find size of what you whant remove

ADD two expression to find where you start in the right function

and after you get a phrase without The Dog!!!!

SV:Help with Mid/Index function

johnw — Thu, 02 Sep 2010 23:13:51 GMT

Field = 'The Dog walked into the room. The Dog did something else.'

mid(Field,len('The Dog ')) = 'walked into the room. The Dog did something else.'
subfield(Field,'The Dog ',2) = 'walked into the room. '
subfield(Field,'The Dog ',-1) = 'did something else.'

SV:Help with Mid/Index function

rwunderlich — Fri, 03 Sep 2010 05:22:13 GMT


saffatwist wrote:
Basically, I'd like to return all the text to the right of the end of 'The Dog '
So, if the text is 'The Dog jumped into the pool', I always want to return all text to the right of 'The Dog '. ie. 'jumped into the pool'

TextBetween(Field, 'The Dog', '')

-Rob