extract_unitid_IR_OpenRefine.json

[
  {
    "op": "core/column-addition",
    "description": "Create column test at index 2 based on column Column 1 using expression grel:value.parseHtml().select(\"unitid\").toString()",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "test",
    "columnInsertIndex": 2,
    "baseColumnName": "Column 1",
    "expression": "grel:value.parseHtml().select(\"unitid\").toString()",
    "onError": "store-error"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column test using expression grel:value.replace('<unitid>','').replace('</unitid>', ';')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "test",
    "expression": "grel:value.replace('<unitid>','').replace('</unitid>', ';')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-split",
    "description": "Split column test by separator",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "test",
    "guessCellType": true,
    "removeOriginalColumn": true,
    "mode": "separator",
    "separator": " ; ",
    "regex": false,
    "maxColumns": 0
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column test 1 using expression value.trim()",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "test 1",
    "expression": "value.trim()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column test 1 using expression value.replace(/\\s+/,' ')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "test 1",
    "expression": "value.replace(/\\s+/,' ')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-split",
    "description": "Split column test 1 by separator",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "test 1",
    "guessCellType": true,
    "removeOriginalColumn": true,
    "mode": "separator",
    "separator": " ; ",
    "regex": false,
    "maxColumns": 0
  },
  {
    "op": "core/transpose-columns-into-rows",
    "description": "Transpose cells in 185 column(s) starting with test 1 1 into rows in one new column named unitid",
    "startColumnName": "test 1 1",
    "columnCount": 185,
    "ignoreBlankCells": true,
    "fillDown": false,
    "combinedColumnName": "unitid",
    "prependColumnName": false,
    "separator": ":"
  },
  {
    "op": "core/column-removal",
    "description": "Remove column Column 1",
    "columnName": "Column 1"
  },
  {
    "op": "core/fill-down",
    "description": "Fill down cells in column File",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "File"
  }
]