Open Refine
Open Refine
Open Refine
University of Aberdeen, University of Queen Meston Walk Aberdeen United AB24 3UE
Queen Mother Library, Abderdeen Mother Kingdom
Meston Walk, Library
ABERDEEN, AB24 3UE,
United Kingdom
Importing Data into OpenRefine
Common
Transformation Action GREL expression
To Uppercase Converts the current value to value.toUppercase()
uppercase
To Lowercase Converts the current value to value.toLowercase()
lowercase
To Titlecase Converts the current value to value.toTitlecase()
titlecase (i.e. each word starts with
an uppercase character and all other
characters are converted to
lowercase)
Trim leading and Removes any ‘whitespace’ value.trim()
trailing characters (e.g. spaces, tabs) from
whitespace the start or end of the current value
Sample Workflow: Author Affiliations
• Openrefine.org
• Openrefine.github.com
• librarycarpentry.github.io/lc-open-refine/
• librarycarpentry.github.io/lc-open-refine/13-
looking-up-data/index.html
• github.com/OpenRefine/OpenRefine/wiki/Gener
al-Refine-Expression-Language
• github.com/OpenRefine/OpenRefine/wiki/Cluster
ing-In-Depth
Questions?
Email: Candace.Norton@nih.gov
Visit: www.nihlibrary.nih.gov/bibliometrics