String Comparison

[mambi]

Hi everyone,

in my project i want to compare 2 fields (load script);  usually under sqlserver i use this functions : Levenshtein or Soundex

but in QV what are the equivalent ?,

i found this function metaphone simple to use ( no documentation )

Any idea ?

[Roop]

I asked the same question a number of months ago and am still waiting for some kind of answer. I think that the only way in which to do anything like this is to use wildcards in a search (which is not the same at all).

On a list bar you can use the fuzzy search by right clicking on the list bar or typing "~"

Sorry not to help further

[swuehl]

There are no built in functions in QV like those requested.

But if you search the forum, you might find some useful approaches (depending on your requirements):

Approximate String Matching in QlikView

string matching with fuzzy, trigram (n-gram), levenshtein, etc.

QlikView Vergleichsfunktion

(for a german style Soundex or implement the algorithm from  en.wikipedia.org/wiki/Soundex )