...
To add Accession numbers to the bulk of the existing entries for NPL, BEG and WSA
To Remove leading characters: (such as the entry " , Belton City dump....") This recipe is set to remove leading ',' from the Locality column. Change these variable to suit your needs.
Code Block |
---|
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column Locality using expression grel:value.partition(\", \")[2]",
"engineConfig": {
"facets": [
{
"expression": "value",
"invert": false,
"selectError": false,
"omitError": false,
"name": "LocalityNumber",
"selectBlank": true,
"columnName": "LocalityNumber",
"omitBlank": false,
"type": "list",
"selection": []
}
],
"mode": "row-based"
},
"columnName": "Locality",
"expression": "grel:value.partition(\", \")[2]",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10 |
Adding accession numbers
Code Block | ||||
---|---|---|---|---|
| ||||
[ { "op": "core/mass-edit", "description": "Mass edit cells in column AccessionNumber", "engineConfig": { "facets": [ { "expression": "value", "invert": false, "selectError": false, "omitError": false, "name": "Collection", "selectBlank": false, "columnName": "Collection", "omitBlank": false, "type": "list", "selection": [ { "v": { "v": "NPL", "l": "NPL" } } ] } ], "mode": "row-based" }, "columnName": "AccessionNumber", "expression": "value", "edits": [ { "fromBlank": true, "fromError": false, "from": [], "to": "2000-001" } ] }, { "op": "core/mass-edit", "description": "Mass edit cells in column AccessionNumber", "engineConfig": { "facets": [ { "expression": "value", "invert": false, "selectError": false, "omitError": false, "name": "Collection", "selectBlank": false, "columnName": "Collection", "omitBlank": false, "type": "list", "selection": [ { "v": { "v": "WSA", "l": "WSA" } } ] } ], "mode": "row-based" }, "columnName": "AccessionNumber", "expression": "value", "edits": [ { "fromBlank": true, "fromError": false, "from": [], "to": "1980-001" } ] }, { "op": "core/mass-edit", "description": "Mass edit cells in column AccessionNumber", "engineConfig": { "facets": [ { "expression": "value", "invert": false, "selectError": false, "omitError": false, "name": "Collection", "selectBlank": false, "columnName": "Collection", "omitBlank": false, "type": "list", "selection": [ { "v": { "v": "BEG", "l": "BEG" } } ] } ], "mode": "row-based" }, "columnName": "AccessionNumber", "expression": "value", "edits": [ { "fromBlank": true, "fromError": false, "from": [], "to": "1970-001" } ] } ] |
...