GREL-saved-tools.md

Add new column, based on this column and extract RDF URI

cell.recon.match.id

Merging several columns

(copied from Recipes) You'd need to use the 'cells' variable:

cells["col1"].value + cells["col2"].value

If any of cells in the columns are blank, the merge will fail for that row. To fix, create a facet of blank cells with "Text Facet" ⇒ "Customized Facets" ⇒ "Facet by Blank". Then use "Edit Cells" ⇒ "Transform ..." and enter a string with a space: ' '.

Using Regex to Custom Text Facet to find broken URL

Accidentally left out the level "id" in the URL for just 12 entries.

value.match(/(.*)(\/authors\/\d{9})(.*)/)

Finds the link, finds the relevant section and sees authors abutts the PID, and then facets on that. Then I simply replaced substring.

value.replace("authors","authors/id")