topic summary of string field full words in QlikView

summary of string field full words

Tue, 02 Aug 2011 15:02:49 GMT

Hi Everyone,

I have a text field with words and sentences in (i.e. a full commentary field). I want to create another field that has a summary of said field with a limit of words or length but remaining as full words. If I use the left() function obviously it counts characters so all of my summaries end with broken words. Can anyone think of a simple solution?

As an example,

'The quick brown fox jumped over the lazy dog' let's say I want to restrict this field to a maximum of 12 characters but only include full words. So I'm happy if it is less than 12 characters as long as it has full words up to that point.

Thanks

Gareth

summary of string field full words

danielrozental — Tue, 02 Aug 2011 15:11:56 GMT

you could keep the first 12 characters, find the last space and then keep the text up to that space.

Something like

=left(var1,index(left(var1,12),' ',-1))

summary of string field full words

Tue, 02 Aug 2011 15:17:49 GMT

Hi Garteh, you could also try the following, that finds the next space of the truncated string and completes the last word.

Regards

=left(vstr,12) & subfield(subfield(vstr,left(vstr,12),-1),' ',1)

summary of string field full words

Tue, 02 Aug 2011 15:54:04 GMT

Thanks both very helpful answers!!