Appendix A. Regular Expressions and GREL
Two more utilities are available in the advanced OpenRefine user's toolbox: regular expressions and GREL. Regular expressions are patterns for matching and replacing text that come in very handy when dealing with large quantities of data. The General Refine Expression Language, GREL, gives you access to a bit of programming power for those cases where a specialized manipulation is necessary. This appendix will introduce you to both techniques.
Regular expressions for text patterns
OpenRefine offers many ways to find the data you need. But what if you don't know the exact text, or more commonly with large datasets, what if the text slightly varies from cell-to-cell? While finding all cells with a value that ...
Get Using OpenRefine now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
