topic Re: String function in script in QlikView

String function in script

Thu, 06 Sep 2012 16:40:54 GMT

Hello,

I have hopefully a very straightforward question that I just can't resolved. I have a particular field that displays data in the format "John Test TT - RRR" etc. I want it to be simply displayed as "John Test" so require " TT - RRR" to be removed. I've tried a range of string functions but haven't been able to get the correct answer. Thanks in advance,

Ralph

Re: String function in script

whiteline — Thu, 06 Sep 2012 16:47:44 GMT

Try SubField([your string], ' TT', 1)

Re: String function in script

Thu, 06 Sep 2012 16:50:14 GMT

Sorry I should have made clear that "TT" and "RRR" can be different values and the RRR value can change in length (usually 2, 3 or 4 characters). Thanks

Re: String function in script

Anonymous — Thu, 06 Sep 2012 16:54:53 GMT

Ralph,

That means the the question is about the rules. Does it mean you need to remove the part of the string staring from the 2nd space?

Regards,

Michael

Re: String function in script

Thu, 06 Sep 2012 16:56:57 GMT

Michael,

Yes anything starting from the 2nd space should be purged from the string.

Thanks,

Ralph

Re: String function in script

Anonymous — Thu, 06 Sep 2012 16:58:44 GMT

Try this:

left('John Test TT - RRR', index('John Test TT - RRR', ' ', 2))

Edit: If the name can be more than two words (John Lesley Test), you can count spaces from the end, assuming there are three:

left(Field, index(Field, ' ', -3))

Re: String function in script

Thu, 06 Sep 2012 17:02:08 GMT

Yes that works brilliant. Many thanks,

Ralph

Re: String function in script

Thu, 06 Sep 2012 17:15:41 GMT

Sorry just noticed one further thing with the below, there is a space after the name, e.g. "John Test ", how can I make it simply "John Test" with no space after Test?

Thanks again,

Ralph

Re: String function in script

Anonymous — Thu, 06 Sep 2012 17:19:02 GMT

Either put the whole thing inside trim() function - it removes leading and trainling spaces, or modify the expression a little by adding -1:

left('John Test TT - RRR', index('John Test TT - RRR', ' ', 2)-1)

Re: String function in script

Thu, 06 Sep 2012 17:21:58 GMT

Works great, thanks again.

Re: String function in script

preminqlik — Fri, 01 Mar 2013 11:20:38 GMT

in script write

let Vname=trim(replace('John Test TT - RRR','TT - RRR',' '));

now select it where ever you want in your sheet by front end with "Vname"

...

Thanks for asking this question .

thank you

-premhas