Basic tutorial to clean up some date using OpenRefine. Great example of well structure GREL syntax to build complex transformation.
Read the full article on Hermanes Barbara's blog.
Read the full article on Hermanes Barbara's blog.
Showing posts with label regex. Show all posts
Showing posts with label regex. Show all posts
31.10.12
23.1.12
Remove all number from a string
To remove all digits value from a string the following regex should do the work (from the menu edit cell > transform):
replace(value, /\d/, '')
This expression replace all numbers (identified by the regular expression /\d/) by blank.
All regular expression (regex) in google refine should starts and ends by the character: /
13.10.11
Extract number from a string
To extract a string of number with a particular length (for example a string of 3 numbers) from a cells we will use the expression match and regex language. This is an easy four steps process
Subscribe to:
Posts (Atom)