Grel to apply to ALL columns or current column

Question

I have a transposition that I'd like to apply to multiple columns. The Grel generated shows the columnName or Base name, but that means I have to edit the code for each column. Thought there was a way to find the column index and have code that would apply to the "current" column, a list of columns by index or all columns.

Specifically, I'd like to trim whitespaces and have 20+ columns.

Explored foreach and row.index but can't find anything like column index.

score 1 · Accepted Answer · answered Mar 13 '14 at 14:49

1

Unfortunately multi-column operations are not supported by the current version of Refine.

answered Mar 13 '14 at 14:49

Tom Morris

10,490
32
53

Thanks Tom. That could be a very useful feature. – Aubrey Mar 01 '16 at 13:24
Apply to GREL to multiple columns is now supported in OpenRefine 2.7 – magdmartin Sep 06 '17 at 03:59

score 1 · Answer 2 · edited Oct 17 '19 at 00:59

1

I have been able to trim leading and trailing white space for entire projects with OpenRefine 3.2.

A standard column gets added to all projects "all". At the top of the "all" column click the down arrow > select "Transform", then in the Expression box enter value.trim() and click ok.

Next you will be allowed to select via check box the columns you would like transformed. Click ok & that should run over all selected columns for your project.

edited Oct 17 '19 at 00:59

J. Scott Elblein

4,013
15
58
94

answered Oct 16 '19 at 18:19

WorkBoots

21
2

This should be the accepted answer, even though it came over 5 years after the OP. – RolfBly Dec 14 '22 at 12:47

Grel to apply to ALL columns or current column

2 Answers2