Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hii,
Whats is the difference between Pick and Match
What is Fuzzy search
Thank u in advance
Hita
Pick returns the nth expression in the list
pick(n, expr1[ , expr2,...exprN])
Pick( 2, 'A','B' ) returns B
Match compares strings and return yhe position of the one found
match( str, expr1 [ , expr2,...exprN ] )
Match( myField, 'Jan','Feb','Mar') return 2 id myField is Feb
From Help:
Fuzzy search is similar to standard search, with the exception that it compares and sorts all field values according to their degree of resemblance to the search string. Fuzzy search is especially useful in situations where misspelling is an issue. It can also help you find multiple values that are nearly identical to each other.