O'Reilly logo

Using OpenRefine by Max De Wilde, Ruben Verborgh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required