[
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "UIC Faculty or Staff",
          "uic faculty or staff",
          "uic faculty or Staff",
          "Uic faculty or staff",
          "Uic Faculty or Staff",
          "uIC Faculty or Staff",
          "uic Faculty or Staff"
        ],
        "to": "UIC Faculty or Staff"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Other",
          "other",
          "other "
        ],
        "to": "Other"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "UIC Student",
          "uic student"
        ],
        "to": "UIC Student"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "student",
          "Student"
        ],
        "to": "UIC Student"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "UIC Students",
          "uic students"
        ],
        "to": "UIC Student"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Ready Reference",
          "ready reference",
          "ready Reference",
          "Ready reference"
        ],
        "to": "Ready Reference"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Technology Assistance",
          "technology assistance",
          "technology Assistance",
          "Technology assistance"
        ],
        "to": "Technology Assistance"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "In-Depth Reference",
          "in-depth reference",
          "in-Depth Reference"
        ],
        "to": "In-Depth Reference"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "in depth reference",
          "In depth reference"
        ],
        "to": "In-Depth Reference"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Directional",
          "directional"
        ],
        "to": "Directional"
      }
    ]
  },
  {
    "op": "core/column-removal",
    "description": "Remove column Notes",
    "columnName": "Notes"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Time using expression value.trim()",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value.trim()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "1:00"
        ],
        "to": "13:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "1:00-2:00"
        ],
        "to": "13:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "1:00:00"
        ],
        "to": "13:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "10:00-11:00"
        ],
        "to": "10:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "10:00:00"
        ],
        "to": "10:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "11:00-12:00"
        ],
        "to": "11:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "11:00:00"
        ],
        "to": "11:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "12:00-1:00"
        ],
        "to": "12:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "12:00:00"
        ],
        "to": "12:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "2:00"
        ],
        "to": "14:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "2:00-3:00"
        ],
        "to": "14:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "2:00:00"
        ],
        "to": "14:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "3:00"
        ],
        "to": "15:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "3:00-4:00"
        ],
        "to": "15:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "3:00:00"
        ],
        "to": "15:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "4:00"
        ],
        "to": "16:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "4:00-5:00"
        ],
        "to": "16:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "4:00:00"
        ],
        "to": "16:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "5:00"
        ],
        "to": "17:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "5:00-6:00"
        ],
        "to": "17:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "5:00:00"
        ],
        "to": "17:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8;30"
        ],
        "to": "08:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8:00"
        ],
        "to": "08:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8:00:00"
        ],
        "to": "08:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8:15:00"
        ],
        "to": "08:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8:30"
        ],
        "to": "08:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8:30-9:00"
        ],
        "to": "08:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8:30:00"
        ],
        "to": "08:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "9:00"
        ],
        "to": "09:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "9:00-10:00"
        ],
        "to": "09:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "9:00:00"
        ],
        "to": "09:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Time",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Time",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "9:09:00"
        ],
        "to": "09:00"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          ""
        ],
        "to": "UIC Student"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "i"
        ],
        "to": "UIC Student"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "not identified"
        ],
        "to": "UIC Student"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Sudent"
        ],
        "to": "UIC Student"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "uic fac"
        ],
        "to": "UIC Faculty or Staff"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "uic fact"
        ],
        "to": "UIC Faculty or Staff"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "UIC Faculty and Staff"
        ],
        "to": "UIC Faculty or Staff"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Patron Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Patron Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": true,
        "fromError": false,
        "from": [],
        "to": "UIC Student"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "d"
        ],
        "to": "Directional"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "duir"
        ],
        "to": "Directional"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "In-Depth Referece"
        ],
        "to": "In-Depth Reference"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "no question type recorded"
        ],
        "to": "Ready Reference"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "not specified"
        ],
        "to": "Ready Reference"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "O"
        ],
        "to": "Ready Reference"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "Technology Reference"
        ],
        "to": "Technology Assistance"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "y"
        ],
        "to": "Ready Reference"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Question Type",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Question Type",
    "expression": "value",
    "edits": [
      {
        "fromBlank": true,
        "fromError": false,
        "from": [],
        "to": "Ready Reference"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Date",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Date",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "###############################################################################################################################################################################################################################################################"
        ],
        "to": "CHANGE ME"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Date",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Date",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "CHANGE ME"
        ],
        "to": "9/20/2008"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Date",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Date",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "8/7/3009"
        ],
        "to": "8/7/2009"
      }
    ]
  }
]