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: /

Read More

Delete multiple projects at once (using the explorer)

At the end of a large project, you may have created multiple of google refine projects and want to clear them from the Open Project view. Screenshot (click on picture to enlarge it) below are from google refine 2.5. The same process is applicable to previous version, only the button browse workspace directory changed is place.

Read More

add extra rows / records in google refine

Google refine does not offer a native way to add rows in a project. As said in the discussion list, the purpose of google refine is not to be a spreadsheet editor and should not be consider for records creation but more analysis and mass edit.

Read More

facet by facet count

Google refine offers the possibilities to facet by name or choice count. This can be useful to focus an analysis or transformation only on value having more than twenty records for example.

Read More

Sort facet by name using toTitlecase(value) expression

When using the text facet option, google refine, sort all available value either by choice count or by name. When sorting by name, all values will be sorted by number first and then by alphabetical order (capital first and then lower case) into something like this:

Read More

Google refine 2.5 RC 2 overview

The 2.5 release candidate is available since Nov 18 and give some interesting insight of what's coming next for google refine. Main change have been done on the welcome interface with three screens to create, open or import an project and a project creation process deeply reworked.

December 12 update

the final release of google refine 2.5 is out. Have fun!

(download google refine 2.5 for free!)

Read More

Replace month name by month number

An other quick JSON code to cut and past in your project and gain some time. This one replace all English month by their number so January becomes 01 ; February 02 and so on. It is based on the function replace and will avoid you to repeat the same action 12 times. Here a simple replace in bloc note (to update your column name) and apply and the trick is done.

Read More