...
Code Block | ||||
---|---|---|---|---|
| ||||
{ "op": "core/text-transform", "description": "Text transform on cells in column Collection using expression grel:value + \"000\"[0,3-value.length()]", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Collection", "expression": "grel:value + \"000\"[0,3-value.length()]", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Specimen. # using expression grel:\"00000000\"[0,8-value.length()] + value", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Specimen. #", "expression": "grel:\"00000000\"[0,8-value.length()] + value", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/mass-edit", "description": "Mass edit cells in column Suffix", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Suffix", "expression": "value", "edits": [ { "fromBlank": false, "fromError": false, "from": [ "." ], "to": "000" } ] }, { "op": "core/text-transform", "description": "Text transform on cells in column Suffix using expression grel:\"000\"[0,3-value.length()] + value", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Suffix", "expression": "grel:\"000\"[0,3-value.length()] + value", "onError": "keep-original", "repeat": false, "repeatCount": 10 } ] |
...