EBSCO Full Conversion Macro

[
  {
    "op": "core/row-removal",
    "description": "Remove rows",
    "engineConfig": {
      "mode": "row-based",
      "facets": [
        {
          "omitError": false,
          "expression": "isBlank(value)",
          "selectBlank": false,
          "invert": false,
          "selectError": false,
          "selection": [
            {
              "v": {
                "v": true,
                "l": "true"
              }
            }
          ],
          "name": "FULLTEXT_START",
          "omitBlank": false,
          "type": "list",
          "columnName": "FULLTEXT_START"
        }
      ]
    }
  },
  {
    "op": "core/column-rename",
    "description": "Rename column TITLE to PublicationTitle",
    "oldColumnName": "TITLE",
    "newColumnName": "PublicationTitle"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column URLBASE to tipp.url",
    "oldColumnName": "URLBASE",
    "newColumnName": "tipp.url"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column RESOURCE to package.name",
    "oldColumnName": "RESOURCE",
    "newColumnName": "package.name"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column PUBLISHER to org.publisher.name",
    "oldColumnName": "PUBLISHER",
    "newColumnName": "org.publisher.name"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column ISSN to title.identifier.issn",
    "oldColumnName": "ISSN",
    "newColumnName": "title.identifier.issn"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column FULLTEXT_START to DateFirstPackageIssue",
    "oldColumnName": "FULLTEXT_START",
    "newColumnName": "DateFirstPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column FULLTEXT_END to DateLastPackageIssue",
    "oldColumnName": "FULLTEXT_END",
    "newColumnName": "DateLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column EMBARGO to KBARTEmbargo",
    "oldColumnName": "EMBARGO",
    "newColumnName": "KBARTEmbargo"
  }
  {
    "op": "core/column-rename",
    "description": "Rename column DB_IDENTIFIER to title.identifier.ebsco",
    "oldColumnName": "DB_IDENTIFIER",
    "newColumnName": "title.identifier.ebsco"
  }
  {
    "op": "core/column-addition",
    "description": "Create column platform.host.name at index 12 based on column org.publisher.name using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "platform.host.name",
    "columnInsertIndex": 12,
    "baseColumnName": "org.publisher.name",
    "expression": "\"\"",
    "onError": "keep-original"
  }
  {
    "op": "core/column-addition",
    "description": "Create column title.identifier.eissn at index 12 based on column org.publisher.name using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "title.identifier.eissn",
    "columnInsertIndex": 12,
    "baseColumnName": "org.publisher.name",
    "expression": "\"\"",
    "onError": "keep-original"
  }
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column platform.host.name using expression grel:replace(value,\"\",\"EBSCOhost::{Platform:165562}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "platform.host.name",
    "expression": "grel:replace(value,\"\",\"EBSCOhost::{Platform:165562}\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression value.toDate()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "value.toDate()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 0
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression value.toDate()",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "value.toDate()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 0
  }
]