[ { "op": "core/row-removal", "description": "Remove rows", "engineConfig": { "mode": "row-based", "facets": [ { "omitError": false, "expression": "value", "selectBlank": true, "selection": [], "selectError": false, "invert": false, "name": "Placemark - Point - coordinates", "omitBlank": false, "type": "list", "columnName": "Placemark - Point - coordinates" } ] } }, { "op": "core/text-transform", "description": "Text transform on cells in column Placemark - description using expression grel:value.replace('

','').replace('

',';').replace('','').replace('','').replace('
','')", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Placemark - description", "expression": "grel:value.replace('

','').replace('

',';').replace('','').replace('','').replace('
','')", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/column-split", "description": "Split column Placemark - description by separator", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Placemark - description", "guessCellType": true, "removeOriginalColumn": false, "mode": "separator", "separator": ";", "regex": false, "maxColumns": 0 }, { "op": "core/column-rename", "description": "Rename column Placemark - description 1 to Site", "oldColumnName": "Placemark - description 1", "newColumnName": "Site" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 2 to Site type", "oldColumnName": "Placemark - description 2", "newColumnName": "Site type" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 3 to Location", "oldColumnName": "Placemark - description 3", "newColumnName": "Location" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 4 to DOC Conservancy", "oldColumnName": "Placemark - description 4", "newColumnName": "DOC Conservancy" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 5 to NZTM Coordinates", "oldColumnName": "Placemark - description 5", "newColumnName": "NZTM Coordinates" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 6 to NZMG Coordinates", "oldColumnName": "Placemark - description 6", "newColumnName": "NZMG Coordinates" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 7", "columnName": "Placemark - description 7" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 8 to Radiocarbon", "oldColumnName": "Placemark - description 8", "newColumnName": "Radiocarbon" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 9 to Sample material", "oldColumnName": "Placemark - description 9", "newColumnName": "Sample material" }, { "op": "core/column-rename", "description": "Rename column Placemark - description 10 to Source of Sample", "oldColumnName": "Placemark - description 10", "newColumnName": "Source of Sample" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 11", "columnName": "Placemark - description 11" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 12", "columnName": "Placemark - description 12" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 13", "columnName": "Placemark - description 13" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 15", "columnName": "Placemark - description 15" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 16", "columnName": "Placemark - description 16" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 17", "columnName": "Placemark - description 17" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 18", "columnName": "Placemark - description 18" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 19", "columnName": "Placemark - description 19" }, { "op": "core/column-removal", "description": "Remove column Placemark - description 14", "columnName": "Placemark - description 14" }, { "op": "core/text-transform", "description": "Text transform on cells in column Site using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Site", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Site type using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Site type", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Location using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Location", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column DOC Conservancy using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "DOC Conservancy", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column NZTM Coordinates using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "NZTM Coordinates", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column NZMG Coordinates using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "NZMG Coordinates", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Radiocarbon using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Radiocarbon", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Sample material using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Sample material", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Source of Sample using expression grel:value.split(\":\")[1]", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Source of Sample", "expression": "grel:value.split(\":\")[1]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/column-move", "description": "Move column Placemark - Point - coordinates to position 11", "columnName": "Placemark - Point - coordinates", "index": 11 }, { "op": "core/column-move", "description": "Move column NZTM Coordinates to position 0", "columnName": "NZTM Coordinates", "index": 0 }, { "op": "core/column-addition", "description": "Create column Easting at index 1 based on column NZTM Coordinates using expression grel:value[0,9]", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "Easting", "columnInsertIndex": 1, "baseColumnName": "NZTM Coordinates", "expression": "grel:value[0,9]", "onError": "set-to-blank" }, { "op": "core/column-addition", "description": "Create column Northing at index 1 based on column NZTM Coordinates using expression grel:value[13,20]", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "Northing", "columnInsertIndex": 1, "baseColumnName": "NZTM Coordinates", "expression": "grel:value[13,20]", "onError": "set-to-blank" }, { "op": "core/column-move", "description": "Move column Placemark - description to position 13", "columnName": "Placemark - description", "index": 13 } ]