Transform volume, number, date information formatted like "1:1 (1919)"
[ { "op": "core/column-split", "description": "Split column PDF Starts by separator", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "PDF Starts", "guessCellType": false, "removeOriginalColumn": true, "mode": "separator", "separator": ":", "regex": false, "maxColumns": 0 }, { "op": "core/column-rename", "description": "Rename column PDF Starts 1 to VolumeFirstPackageIssue", "oldColumnName": "PDF Starts 1", "newColumnName": "VolumeFirstPackageIssue" }, { "op": "core/column-split", "description": "Split column PDF Starts 2 by separator", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "PDF Starts 2", "guessCellType": true, "removeOriginalColumn": true, "mode": "separator", "separator": "(", "regex": false, "maxColumns": 0 }, { "op": "core/column-rename", "description": "Rename column PDF Starts 2 1 to NumberFirstPackaegIssue", "oldColumnName": "PDF Starts 2 1", "newColumnName": "NumberFirstPackaegIssue" }, { "op": "core/text-transform", "description": "Text transform on cells in column PDF Starts 2 2 using expression grel:replace(value,\")\",\"\")", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "PDF Starts 2 2", "expression": "grel:replace(value,\")\",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/column-rename", "description": "Rename column PDF Starts 2 2 to DateFirstPackageIssue", "oldColumnName": "PDF Starts 2 2", "newColumnName": "DateFirstPackageIssue" }, { "op": "core/text-transform", "description": "Text transform on cells in column DateFirstPackageIssue using expression value.toDate()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "DateFirstPackageIssue", "expression": "value.toDate()", "onError": "keep-original", "repeat": false, "repeatCount": 0 } ]
Operated as a Community Resource by the Open Library Foundation