Last active
October 30, 2019 12:24
-
-
Save xmorave2/e46ffde46655055bd73a to your computer and use it in GitHub Desktop.
Předpis pro undo/redo funkci openerefine pro vyladění čtenářských záznamů pro import do Kohy
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "op": "core/column-split", | |
| "description": "Split column rcislo by field lengths", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo", | |
| "guessCellType": true, | |
| "removeOriginalColumn": true, | |
| "mode": "lengths", | |
| "fieldLengths": [ | |
| 1, | |
| 1, | |
| 1, | |
| 1, | |
| 1, | |
| 1 | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "L" | |
| ], | |
| "to": "199" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "T" | |
| ], | |
| "to": "190" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "^" | |
| ], | |
| "to": "198" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| ")" | |
| ], | |
| "to": "197" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "M" | |
| ], | |
| "to": "196" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "o" | |
| ], | |
| "to": "195" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "190" | |
| ], | |
| "to": "200" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "(" | |
| ], | |
| "to": "194" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "8" | |
| ], | |
| "to": "193" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "y" | |
| ], | |
| "to": "192" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "u" | |
| ], | |
| "to": "201" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 1", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 1", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "C" | |
| ], | |
| "to": "191" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "(" | |
| ], | |
| "to": "4" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "8" | |
| ], | |
| "to": "3" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| ")" | |
| ], | |
| "to": "7" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "^" | |
| ], | |
| "to": "8" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "|" | |
| ], | |
| "to": "0" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "C" | |
| ], | |
| "to": "1" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "L" | |
| ], | |
| "to": "9" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "M" | |
| ], | |
| "to": "6" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "o" | |
| ], | |
| "to": "5" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 2", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 2", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "y" | |
| ], | |
| "to": "2" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 3", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 3", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "|" | |
| ], | |
| "to": "0" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 3", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 3", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "C" | |
| ], | |
| "to": "1" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "(" | |
| ], | |
| "to": "4" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "8" | |
| ], | |
| "to": "3" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| ")" | |
| ], | |
| "to": "7" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "^" | |
| ], | |
| "to": "8" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "|" | |
| ], | |
| "to": "0" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "C" | |
| ], | |
| "to": "1" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "L" | |
| ], | |
| "to": "9" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "M" | |
| ], | |
| "to": "6" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "o" | |
| ], | |
| "to": "5" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 4", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 4", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "y" | |
| ], | |
| "to": "2" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 5", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 5", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "|" | |
| ], | |
| "to": "0" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 5", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 5", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "8" | |
| ], | |
| "to": "3" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 5", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 5", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "C" | |
| ], | |
| "to": "1" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 5", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 5", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "y" | |
| ], | |
| "to": "2" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "2" | |
| ], | |
| "to": "4" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "9" | |
| ], | |
| "to": "0" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "7" | |
| ], | |
| "to": "2" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "6" | |
| ], | |
| "to": "7" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| ":" | |
| ], | |
| "to": "1" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "]" | |
| ], | |
| "to": "9" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "@" | |
| ], | |
| "to": "1" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "=" | |
| ], | |
| "to": "0" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "a" | |
| ], | |
| "to": "3" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "b" | |
| ], | |
| "to": "4" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "c" | |
| ], | |
| "to": "8" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "d" | |
| ], | |
| "to": "3" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "e" | |
| ], | |
| "to": "9" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "G" | |
| ], | |
| "to": "6" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "I" | |
| ], | |
| "to": "6" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "k" | |
| ], | |
| "to": "5" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "n" | |
| ], | |
| "to": "2" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "Q" | |
| ], | |
| "to": "5" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "V" | |
| ], | |
| "to": "8" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column rcislo 6", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "rcislo 6", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "X" | |
| ], | |
| "to": "7" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/column-addition", | |
| "description": "Create column dateofbirth at index 14 based on column rcislo 1 using expression grel:value+cells[\"rcislo 2\"].value+\"-\"+cells[\"rcislo 3\"].value+cells[\"rcislo 4\"].value+\"-\"+cells[\"rcislo 5\"].value+cells[\"rcislo 6\"].value", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "newColumnName": "dateofbirth", | |
| "columnInsertIndex": 14, | |
| "baseColumnName": "rcislo 1", | |
| "expression": "grel:value+cells[\"rcislo 2\"].value+\"-\"+cells[\"rcislo 3\"].value+cells[\"rcislo 4\"].value+\"-\"+cells[\"rcislo 5\"].value+cells[\"rcislo 6\"].value", | |
| "onError": "set-to-blank" | |
| }, | |
| { | |
| "op": "core/column-removal", | |
| "description": "Remove column rcislo 1", | |
| "columnName": "rcislo 1" | |
| }, | |
| { | |
| "op": "core/column-removal", | |
| "description": "Remove column rcislo 2", | |
| "columnName": "rcislo 2" | |
| }, | |
| { | |
| "op": "core/column-removal", | |
| "description": "Remove column rcislo 3", | |
| "columnName": "rcislo 3" | |
| }, | |
| { | |
| "op": "core/column-removal", | |
| "description": "Remove column rcislo 4", | |
| "columnName": "rcislo 4" | |
| }, | |
| { | |
| "op": "core/column-removal", | |
| "description": "Remove column rcislo 5", | |
| "columnName": "rcislo 5" | |
| }, | |
| { | |
| "op": "core/column-removal", | |
| "description": "Remove column rcislo 6", | |
| "columnName": "rcislo 6" | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column categorycode", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "categorycode", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "I" | |
| ], | |
| "to": "Z" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column categorycode", | |
| "engineConfig": { | |
| "facets": [], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "categorycode", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| " " | |
| ], | |
| "to": "DOSP" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column categorycode", | |
| "engineConfig": { | |
| "facets": [ | |
| { | |
| "invert": false, | |
| "expression": "grel:substring(value, 0, 4)", | |
| "selectError": false, | |
| "omitError": false, | |
| "selectBlank": false, | |
| "name": "dateofbirth", | |
| "omitBlank": false, | |
| "columnName": "dateofbirth", | |
| "type": "list", | |
| "selection": [ | |
| { | |
| "v": { | |
| "v": "2002", | |
| "l": "2002" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2003", | |
| "l": "2003" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2004", | |
| "l": "2004" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2005", | |
| "l": "2005" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2006", | |
| "l": "2006" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2007", | |
| "l": "2007" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2008", | |
| "l": "2008" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2009", | |
| "l": "2009" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2010", | |
| "l": "2010" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2011", | |
| "l": "2011" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2012", | |
| "l": "2012" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2013", | |
| "l": "2013" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2014", | |
| "l": "2014" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2015", | |
| "l": "2015" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "2016", | |
| "l": "2016" | |
| } | |
| } | |
| ] | |
| } | |
| ], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "categorycode", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "DOSP" | |
| ], | |
| "to": "DITE" | |
| } | |
| ] | |
| }, | |
| { | |
| "op": "core/mass-edit", | |
| "description": "Mass edit cells in column categorycode", | |
| "engineConfig": { | |
| "facets": [ | |
| { | |
| "invert": false, | |
| "expression": "grel:substring(value, 0, 4)", | |
| "selectError": false, | |
| "omitError": false, | |
| "selectBlank": false, | |
| "name": "dateofbirth", | |
| "omitBlank": false, | |
| "columnName": "dateofbirth", | |
| "type": "list", | |
| "selection": [ | |
| { | |
| "v": { | |
| "v": "1929", | |
| "l": "1929" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1930", | |
| "l": "1930" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1931", | |
| "l": "1931" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1932", | |
| "l": "1932" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1933", | |
| "l": "1933" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1934", | |
| "l": "1934" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1935", | |
| "l": "1935" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1936", | |
| "l": "1936" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1937", | |
| "l": "1937" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1938", | |
| "l": "1938" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1939", | |
| "l": "1939" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1940", | |
| "l": "1940" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1941", | |
| "l": "1941" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1942", | |
| "l": "1942" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1943", | |
| "l": "1943" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1944", | |
| "l": "1944" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1945", | |
| "l": "1945" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1946", | |
| "l": "1946" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1947", | |
| "l": "1947" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1948", | |
| "l": "1948" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1949", | |
| "l": "1949" | |
| } | |
| }, | |
| { | |
| "v": { | |
| "v": "1950", | |
| "l": "1950" | |
| } | |
| } | |
| ] | |
| } | |
| ], | |
| "mode": "row-based" | |
| }, | |
| "columnName": "categorycode", | |
| "expression": "value", | |
| "edits": [ | |
| { | |
| "fromBlank": false, | |
| "fromError": false, | |
| "from": [ | |
| "DOSP" | |
| ], | |
| "to": "SEN" | |
| } | |
| ] | |
| } | |
| ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Provést aktualizaci na rok 2020?
(Dosp >> Dite)