topic Re: Word Search (Whole Word) in QlikView https://community.qlik.com/t5/QlikView/Word-Search-Whole-Word/m-p/480018#M179390 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 16 Oct 2013 16:44:02 GMT fsimoes81 2013-10-16T16:44:02Z Word Search (Whole Word) https://community.qlik.com/t5/QlikView/Word-Search-Whole-Word/m-p/480016#M179388 <HTML><HEAD></HEAD><BODY><P>Word Search,</P><P>I need find a string inside a text, but need to be a whole word.</P><P></P><P>Like this example:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Model</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Company Model</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>24H</P></TD><TD style="padding: 2px;"><SPAN class="hps">Wheel Loader</SPAN> 924H</TD></TR><TR><TD style="padding: 2px;">924H</TD><TD style="padding: 2px;"><SPAN class="hps">Wheel Loader</SPAN> 924H</TD></TR></TBODY></TABLE><P></P><P>On example, I need take de seconde value, to use Left(), Right(), Index(), etc, is not possible, because this is a simple example, mas has many variations.</P><P>If SubstringCount() or WildMatch(), allowed "whole word" would be perfect.</P><P>Some sugestion, please?</P></BODY></HTML> Wed, 16 Oct 2013 16:01:46 GMT https://community.qlik.com/t5/QlikView/Word-Search-Whole-Word/m-p/480016#M179388 fsimoes81 2013-10-16T16:01:46Z Re: Word Search (Whole Word) https://community.qlik.com/t5/QlikView/Word-Search-Whole-Word/m-p/480017#M179389 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>Use an appropriate delimiter that is not part of your strings (I used '~' for that).</P></BODY></HTML> Wed, 16 Oct 2013 16:17:38 GMT https://community.qlik.com/t5/QlikView/Word-Search-Whole-Word/m-p/480017#M179389 swuehl 2013-10-16T16:17:38Z Re: Word Search (Whole Word) https://community.qlik.com/t5/QlikView/Word-Search-Whole-Word/m-p/480018#M179390 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 16 Oct 2013 16:44:02 GMT https://community.qlik.com/t5/QlikView/Word-Search-Whole-Word/m-p/480018#M179390 fsimoes81 2013-10-16T16:44:02Z