topic Search a string within a string in QlikView

Search a string within a string

Thu, 03 Jun 2010 13:52:46 GMT

I want to search for a string value within a String.

Ex. if you have something like

Product:

green apple

Big apple

yellow apple

green apple small

red big apple

Search for the word Apple in Product and then return only apple?

Thanks,

Thu, 03 Jun 2010 14:31:39 GMT

You can use the index function (string functions) to check for apple.

if (index(Product,'apple') > 0, 'Apple')

Regards

Juerg

Fri, 11 Jun 2010 19:36:30 GMT

Try one of the Match functions:

wildmatch( s, expr1 [ , expr2, ...exprN ] )

Compares the string s to a list of strings or string expressions. The

result of the comparison is an integer indicating which of the comparison

strings/expressions that matched. If no match is found, 0 is

returned. The wildmatch function performs a case insensitive comparison.

The wildcard characters * and ? are allowed in the comparison

string.

Examples:

wildmatch( M , 'ja*' , 'fe?' , 'mar' )

where M is 'January' returns 1

wildmatch( M , 'ja*' , 'fe?' , 'mar' )

where M is 'fex' returns 2