Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titlegeneral format
borderStylesolid
[
  {
    "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.
The following macro has the column headers as they are used by the Specify workbench uploader.

Code Block
titleTrim leading and trailing whitespace
borderStylesolid
[
  {
    "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",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column Era   using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "Era",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   EpochSpecify using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "EpochSpecify",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   SubEpoch using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "SubEpoch",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   PeriodSpecify using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "PeriodSpecify",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   SubSystem/SubPeriod using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "SubSystem/SubPeriod",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   StageSpecify using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "StageSpecify",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   County using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "County",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column State   using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "State",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   Country using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "Country",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   DeterminerLastName using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "DeterminerLastName",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   DeterminerFirstName using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "DeterminerFirstName",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   Identification date using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "Identification date",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   LocalityNumber using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "LocalityNumber",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   Locality using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "Locality",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column   Locality Name using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "Locality Name",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


},


 


{


      "op": "core/text-transform",


      "description": "Text transform on cells in column Notes   using expression value.trim()",


      "engineConfig": {


        "facets": [],


        "mode": "row-based"


      },


      "columnName": "Notes",


      "expression": "value.trim()",


      "onError": "keep-original",


      "repeat": false,


      "repeatCount": 10


}






]