Use of ^ in wildsearch

[mahesh_agrawal]

Does anybody know, what the ^ -sign do in Wildcard Search and how to use it?

Maybe you know any business case applying it?

In a Search Object in QV dashboard (not only there of course), we can use special signs like * or ?, but in the Manual I found information about third special sign: ^ - but I really don't know what does it do....

From manual:

"

If wildcards are used, only those records that match the entire search string will be displayed, that is a blank

does not imply a logical OR. Wildcards may appear several times in the search string, regardless of their location.

The following wildcards can be used:

* zero or more characters

? any single character

^ whole string

"

[Gysbert_Wassenaar]

See here: https://community.qlik.com/blogs/qlikviewdesignblog/2015/03/02/the-search-string#comment-26316

[#3]

This is dicussed in the comments space: The Search String

[avinashelite]

Hi Mahesh,

^A will identify as the starting letter of the word. Its similar to wild search but it will show the words staring with A

[Gabriel]

Hi,

When you use ^ in a search string what you are effectively searching for is any word beginning with, i.e. *^G*, this will search for any word starting with G.

Henric has a blog for search in QlikView.

[awhitfield]

It's used in conduction with other Wildcard characters:

*^ab* Wildcard Returns all values that have words that begin with ab.

Equivalent to a normal search for ab, but unlike the normal search it can be made more complex using wildcards. It can also be used in a programmatic search, such as in Set Analysis.

HTH Andy