Edit value from the facet

 

I just can't believe we have not yet published a tutorial for this essential OpenRefine feature! 

When you select the edit option from the facet menu, you can edit all matching values in a column, similar to a search and replace function. Of course, the update is recorded in OpenRefine history and can be replicated on a similar dataset.

You can use the edit using facet to quickly clean up typos or misspelled cells. It is also useful to address duplicates that are either not detected by the clustering feature or caught in larger clusters with irrelevant matches. 

In this video example below, we replace the value US  to United States for 45 cells in one shot.

Read More

Parsing and extracting HTML tag and links in Refine

I recently helped someone on stackoverflow to parse and extract information from an HTML page.  Refine with GREL offer multiple ways to select specific element and contant. This article will review the main functions and specific use cases to illustrate when to use them.

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

Remove or replace a specific character in a column

You want to remove a space or a specific character from your column like the sign # before some number.

Read More