Metaphone key

[Jawa Siva]

Is there any GREL/Jython function to access the metaphone key or cluster function to compare two strings?

[Thad Guidry]

phonetic() and fingerprint() are useful for this purpose, along with other string functions in GREL like ngram() and unicode()

Here is our wiki page on all of them: https://github.com/OpenRefine/OpenRefine/wiki/GREL-String-Functions#phoneticstring-s-optional-string-encoding

If you need even more power, you can also look at the source of fingerprint() itself and call the Java functions yourself and modify to your liking with GREL (by using Clojure or Jython)

main/src/com/google/refine/clustering/binning/BinningClusterer.java is one of them.

On Mon, Dec 23, 2013 at 8:09 AM, Jawa Siva <rjaw...@gmail.com> wrote:

Is there any GREL/Jython function to access the metaphone key or cluster function to compare two strings?

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

-Thad

+ThadGuidry
Thad on LinkedIn

[Jawa Siva]

Thats cool. Thanks

[Marcelo LaFleur]

Hi,
I'm trying to do the same but I cannot get past the following error:

-Add column based on this column-
GREL expression: phonetic(value)  << I want the metaphone3 code as a new column
 Error: phonetic expects 3 strings

From what I can see, phonetic should only look for 2 strings. Every variation of GREL that I input gives me this code.

Help?
PS: new to Refine.

[Owen Stephens]

It looks like that the phonetic does not assume a default value for the encoding scheme, although the help says it does.

I get the same error with phonetic(value), but 

phonetic(value,'metaphone3')

works for me 

Owen Stephens

Owen Stephens Consulting

Web: http://www.ostephens.com
Email: ow...@ostephens.com
Telephone: 0121 288 6936

For more options, visit https://groups.google.com/d/optout.

[Marcelo LaFleur]

Ah, I was missing the single quotes in the string. Thanks for the help. It works perfectly, though the documentation clearly should be updated (and the error message also).

-- Marcelo

--
You received this message because you are subscribed to a topic in the Google Groups "OpenRefine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/9wbjmEoZNDo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+...@googlegroups.com.

[Thad Guidry]

I have added the example usage to phonetic() on our wiki reference pages.  https://github.com/OpenRefine/OpenRefine/wiki/GREL-String-Functions#phoneticstring-s-optional-string-encoding

Thanks for letting us know !

[Marcelo LaFleur]

Thanks Thad. The documentation should not state that the command defaults to anything. Without the encoding the command returns an error. 

Try:  phonetic(value)

-- Marcelo

[Thad Guidry]

Better ?

https://github.com/OpenRefine/OpenRefine/wiki/GREL-String-Functions#phoneticstring-s-string-encoding

[Marcelo LaFleur]

Looks great!

-- Marcelo