Usage with OpenRefine - RBGKew/String-Transformers GitHub Wiki

Using String Transformers with OpenRefine.

Installation

  1. Download and install OpenRefine.
  2. Download the String Transformers JAR and Apache Commons-Lang3 JAR
  3. Put both JAR files in OpenRefine's webapp/extensions/jython/module/MOD-INF/lib directory
  4. (Re)start OpenRefine.

Usage

  1. Import your data into OpenRefine.
  2. Select the heading of the column you wish to transform and choose Edit columnAdd column based on this column…
  3. Select Jython from the Language dropdown
  4. Use an expression like this:
from org.kew.rmf.transformers import CapitalLettersExtractor

cle = CapitalLettersExtractor()
return cle.transform(value)
  1. Click OK!

align=center

A full list of all Transformers is in the API Documentation.