Menu
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.
758
Cells can be split into additional columns using a separator (often a comma, semi-colon, dash, space, or other character) or field length. Using the dropdown menu for the column you wish split, select "edit column" > "Split into several columns".
Go to the one of columns you would like to join. Select "Edit column" and click "Join columns." Select columns you would like to join and click "OK." You can add separator between the contents of each column.
OpenRefine provides a find/replace function for you to edit your data. Selecting Edit cells → Replace will bring up a simple window where you can input a string to search and a string to replace it with.
Reordering and renaming columns Reorder the columns by clicking the drop-down menu at the top of the first column (labelled 'All'), and choosing Edit columns->Re-order / remove columns … You can then drag and drop column names to reorder the columns, or remove columns completely if they are not required.
Unfortunately multi-column operations are not supported by the current version of Refine.
102
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
