A great link for learning Refine, written by Javier Otegui - https://docs.google.com/document/d/1w7yTY7gRmqGbph4_kZV4fR64Bmn5odfbiFgOmqsRwQY/edit#heading=h.bsrik76besgy
*Others should feel free to add recipes and instructions!*
Refine is now available for download via github.
Google wiki: Refine recipe wiki
Some 'recipies' for specific operations with TAGSRV data.
To add Accession numbers to the bulk of the existing entries for NPL, BEG and WSATo Remove leading characters: (such as the entry " , Belton City dump....") This recipe is remove "." from the end of all entries in a column.
- Facet the column using the REGEX string ?.[\.]$
- Select "transform" for the column.
- Paste this into text box
- value.partition(smartSplit(".", " ")[-1])[0]
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"
}
]
}
] |
...
Catalog Number Formatting
| 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
}
] |
...
Filling in some blanks
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
{ "op": "core/mass-edit", "description": "Mass edit cells in column CatalogerLastName", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "CatalogerLastName", "expression": "value", "edits": [ { "fromBlank": true, "fromError": false, "from": [], "to": "Unknown" } ] }, { "op": "core/mass-edit", "description": "Mass edit cells in column CatalogedDate", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "CatalogedDate", "expression": "value", "edits": [ { "fromBlank": true, "fromError": false, "from": [], "to": "01/01/1000" } ] }, { "op": "core/mass-edit", "description": "Mass edit cells in column CollectionType", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "CollectionType", "expression": "value", "edits": [ { "fromBlank": true, "fromError": false, "from": [], "to": "Invertebrate" } ] } ] |
This next bit will allow you to combine all of the old locations into a single string formatted in the 'cage cabinet/drawer' style. The last step takes the newly formatted old locations, and adds them to 'notes'. It also DELETES the now-defunct 'old' columns.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column OldCage using expression grel:\"Old Loc: \" + value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCage",
"expression": "grel:\"Old Loc: \" + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column OldCabinet",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCabinet",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": " "
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column OldDrawer",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldDrawer",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": " "
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column OldCage",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCage",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": " "
}
]
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column OldCage using expression grel:cells[\"OldCage\"].value + \", \" + cells[\"OldCabinet\"].value + \"/\" + cells[\"OldDrawer\"].value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCage",
"expression": "grel:cells[\"OldCage\"].value + \", \" + cells[\"OldCabinet\"].value + \"/\" + cells[\"OldDrawer\"].value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Comments using expression grel:cells[\"OldCage\"].value + \"; \" + cells[\"Comments\"].value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Comments",
"expression": "grel:cells[\"OldCage\"].value + \"; \" + cells[\"Comments\"].value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-removal",
"description": "Remove column OldCage",
"columnName": "OldCage"
},
{
"op": "core/column-removal",
"description": "Remove column OldCabinet",
"columnName": "OldCabinet"
},
{
"op": "core/column-removal",
"description": "Remove column OldDrawer",
"columnName": "OldDrawer"
}
] |
...
To join columns Locality Number and Locality into a pre-exiting column named 'Locality Name'. This field then gets heavily edited to standardize distance units, cardinal direction abbreviations and so on.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column Locality name using expression grel:cells[\"LocalityNumber\"].value + \", \" + cells[\"Locality\"].value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Locality name",
"expression": "grel:cells[\"LocalityNumber\"].value + \", \" + cells[\"Locality\"].value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
] |
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column Locality using expression grel:value.replace(\"Ck.\",\"Creek\")\nvalue.replace(\"Ck,\",\"Creek\")\nvalue.replace(\"Ck.,\",\"Creek\")\nvalue.replace(\"Rd\",\"Road\")\nvalue.replace(\"Rd.\",\"Road\")\nvalue.replace(\"Rd,\",\"Road\")\nvalue.replace(\"Rv\",\"River\")\nvalue.replace(\"Rv.\",\"River\")\nvalue.replace(\"Rv,\",\"River\")",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Locality",
"expression": "grel:value.replace(\"Ck.\",\"Creek\")\nvalue.replace(\"Ck,\",\"Creek\")\nvalue.replace(\"Ck.,\",\"Creek\")\nvalue.replace(\"Rd\",\"Road\")\nvalue.replace(\"Rd.\",\"Road\")\nvalue.replace(\"Rd,\",\"Road\")\nvalue.replace(\"Rv\",\"River\")\nvalue.replace(\"Rv.\",\"River\")\nvalue.replace(\"Rv,\",\"River\"River\")\nvalue.replace(\"Rv,\",\"River\")",
"onError": "keep-original")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
] |
When a spreadsheet has column headers that match the Specify fields, this macro can be run to trim whitespace from all the columns. The general format is:
| Code Block | ||||
|---|---|---|---|---|
| ||||
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column NAME_OF_COLUMN using expression value.trim()",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "NAME_OF_COLUMN",
"expression": "value.trim()",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
] |
This macro tells refine to trim leading and trailing whitespace on the named column, and to display the action on the main page. If more than one column is being trimmed, the last '}' gets a comma added after it.
The following macro has the column headers as they are used by the Specify workbench uploader.
| Code Block | ||||
|---|---|---|---|---|
| ||||
[ { "op": "core/text-transform", "description": "Text transform on cells in column Catalog number using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Catalog number", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Cataloged Date using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cataloged Date", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Cataloger Last Name using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cataloger Last Name", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Cataloger First Name using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cataloger First Name", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Aisle1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Aisle1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Building1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Building1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Room1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Room1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Cabinet1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cabinet1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Drawer1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Drawer1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Inventory Remarks using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Inventory Remarks", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Prepared Last Name By 1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Prepared Last Name By 1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Prepared First Name By 1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Prepared First Name By 1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Inventory Date using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Inventory Date", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Number of pieces 1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Number of pieces 1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Prep Type 1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Prep Type 1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Other Catalog Numbers using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Other Catalog Numbers", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Article/Book Title using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Article/Book Title", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Collection Object Citation2 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Collection Object Citation2", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Remarks (Citation Info) using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Remarks (Citation Info)", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Is Figured 1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Is Figured 1", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Type status using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Type status", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Verbatim date (Collection) using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Verbatim date (Collection)", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Collectors number using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Collectors number", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Remarks (old Series) using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Remarks (old Series)", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Litho Group using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Litho Group", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Formation using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Formation", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Member using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Member", "repeatexpression": false"value.trim()", "repeatCountonError": "keep-original", 10 } ] |
When a spreadsheet has column headers that match the Specify fields, this macro can be run to trim whitespace from all the columns. The general format is:
| Code Block | ||||
|---|---|---|---|---|
| ||||
[ "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column NAME_OF_COLUMNEra using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "NAME_OF_COLUMNEra", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, ] |
This macro tells refine to trim leading and trailing whitespace on the named column, and to display the action on the main page.
The following macro has the column headers as they are used by the Specify workbench uploader.
| Code Block | ||||
|---|---|---|---|---|
| ||||
[ "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Catalog numberEpochSpecify using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Catalog numberEpochSpecify", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Cataloged DateSubEpoch using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cataloged DateSubEpoch", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column CatalogerPeriodSpecify Last Name using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cataloger Last NamePeriodSpecify", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Cataloger First NameSubSystem/SubPeriod using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cataloger First NameSubSystem/SubPeriod", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Aisle1StageSpecify using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Aisle1StageSpecify", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Building1County using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Building1County", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Room1State using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Room1State", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Cabinet1Country using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Cabinet1Country", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Drawer1DeterminerLastName using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Drawer1DeterminerLastName", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column InventoryDeterminerFirstName Remarks using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Inventory RemarksDeterminerFirstName", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Prepared Last Name By 1Identification date using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Prepared Last Name By 1Identification date", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Prepared First Name By 1LocalityNumber using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Prepared First Name By 1LocalityNumber", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Inventory DateLocality using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Inventory DateLocality", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column NumberLocality ofName pieces 1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Number of pieces 1Locality Name", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column PrepNotes Type 1 using expression value.trim()", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Prep Type 1Notes", "expression": "value.trim()", "onError": "keep-original", "repeat": false, "repeatCount": 10 } ] |