topic Re: Using the trim function to shorten names in QlikView

Using the trim function to shorten names

Anonymous — Wed, 21 Jan 2015 18:00:45 GMT

Hello,

I'm having a field which contains long values.

All of them start with an amount of tags that I want to remove since I do not want to see them in the report.

The length and the tags are always different.

All they have in common is that they end with "] " before the actual value that I need to see starts.

I never used the trim function and I'm wondering if it's somehow possible to say:

remove everything before and including "] " and display the rest only.

Re: Using the trim function to shorten names

Colin-Albert — Wed, 21 Jan 2015 18:06:00 GMT

Subfield(yourfieldname, ']', 2)

Re: Using the trim function to shorten names

maxgro — Wed, 21 Jan 2015 18:13:56 GMT

another option could be (in script or in chart)

Right(field, len(field) - index(field, '['))

Re: Using the trim function to shorten names

Anonymous — Wed, 21 Jan 2015 18:33:04 GMT

had to add a space and use the closing brackets.. after that it worked. thanks Massimo.

Re: Using the trim function to shorten names

rwunderlich — Wed, 21 Jan 2015 18:51:12 GMT

The subfield() function can take a negative index, which counts from the right. (It's not clear in the doc). That's convenient for handling a variable number of delimiters.

=Subfield(yourfieldname, ']', -1)

=SubField('[tag1][tag2]mydata',']',-1) = 'mydata'

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Using the trim function to shorten names

MarcoWedel — Wed, 21 Jan 2015 21:57:45 GMT

another one:

Mid(Field, Index(Field, '] ')+2)

just because QlikView offers so many possibilities;-)

regards

Marco

Re: Using the trim function to shorten names

MarcoWedel — Wed, 21 Jan 2015 22:00:20 GMT

TextBetween(Field&'@','] ','@')

Although I find the already proposed subfield() solutions most intuitive.

regards

Marco