[
{
"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
}
]