クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

Query Use of Levenshtein Distance - Case Sensitivity

回答済み
デモをリクエスト

I have a query that utilizes the Levenshtein Distance function to test for similarities between employee names and vendor names within our records. Currently all of the query results have a Levenshtein Distance of 2, but it appears that the function is case-sensitive. Is there a way to eliminate the case sensitivity of this function to just highlight necessary insertions, deletions or substitutions required to produce a matching string and rid the comparison of capitalization across strings?

0

コメント

4件のコメント

日付 投票
  • 正式なコメント
    Tony Scalese

    Glad it worked and we got you off and running.  Come back any time with questions. 

  • Alec Schwager

    For more context - I am worried that a distance of 2 could indicate a matching string that only differs in case. 

    e.g., if the vendor name is 'CAM' and it matches to a name value of 'Cam,' I fear current functionality would return a Levenshtein Distance of 2, when I would prefer it return a distance of 0. 

    0
  • Tony Scalese

    Hi Alec,

    Thanks for using the Community!  Would the use of UPPER be a viable option?

    Ex: levenshtein_distance(UPPER(field1), UPPER(field2))

    Tony

    1
  • Alec Schwager

    Tony,

    That worked like a charm. I did not realize there was a function to temporarily change the case of data only for the sake of a query. Thank you for your quick response!

    Alec

    0

サインインしてコメントを残してください。