﻿[
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column scientificName",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "scientificName",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Ammospermophilus harrisii"
        ],
        "to": "Ammospermophilus harrisi"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column scientificName",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "scientificName",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Ammospermophilis harrisi"
        ],
        "to": "Ammospermophilus harrisi"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column scientificName",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "scientificName",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Amphispiza bilineata",
          "Amphespiza bilineata",
          "Emphispiza bilinata",
          "Amphispiza bilineatus",
          "Amphispizo bilineata"
        ],
        "to": "Amphispiza bilineata"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "  Amphispiza bilineata",
          "  Amphispiza bilineata  "
        ],
        "to": "  Amphispiza bilineata"
      }
    ]
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column scientificName using expression value.trim()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "scientificName",
    "expression": "value.trim()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column scientificName using expression value.trim()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "scientificName",
    "expression": "value.trim()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-split",
    "description": "Split column scientificName by separator",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "scientificName",
    "guessCellType": true,
    "removeOriginalColumn": false,
    "mode": "separator",
    "separator": " ",
    "regex": false,
    "maxColumns": 0
  },
  {
    "op": "core/column-removal",
    "description": "Remove column scientificName",
    "columnName": "scientificName"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column scientificName 1 to genus",
    "oldColumnName": "scientificName 1",
    "newColumnName": "genus"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column species to species_abr",
    "oldColumnName": "species",
    "newColumnName": "species_abr"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column scientificName 2 to species",
    "oldColumnName": "scientificName 2",
    "newColumnName": "species"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column ﻿recordID using expression value.toNumber()",
    "engineConfig": {
      "mode": "row-based",
      "facets": [
        {
          "omitError": false,
          "expression": "value",
          "selectBlank": false,
          "selection": [
            {
              "v": {
                "v": "AH",
                "l": "AH"
              }
            }
          ],
          "selectError": false,
          "invert": false,
          "name": "species_abr",
          "omitBlank": false,
          "type": "list",
          "columnName": "species_abr"
        }
      ]
    },
    "columnName": "﻿recordID",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column ﻿recordID using expression value.toNumber()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "﻿recordID",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column mo using expression value.toNumber()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "mo",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column dy using expression value.toNumber()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "dy",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column yr using expression value.toNumber()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "yr",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column period using expression value.toNumber()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "period",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column species_abr using expression value.toNumber()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "species_abr",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
]
