Versions Compared

Key

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

...

[
  {
    "op": "core/column-addition",
    "description": "Create column platform.host.name at index 1 based on column publication_title using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "platform.host.name",
    "columnInsertIndex": 1,
    "baseColumnName": "publication_title",
    "expression": "\"\"",
    "onError": "keep-original"
  },
  {
    "op": "core/column-addition",
    "description": "Create column package.name at index 2 based on column publication_title using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "package.name",
    "columnInsertIndex": 2,
    "baseColumnName": "publication_title",
    "expression": "\"\"",
    "onError": "keep-original"
  },
  {
    "op": "core/column-addition",
    "description": "Create column org.publisher.name at index 3 based on column publication_title using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "org.publisher.name",
    "columnInsertIndex": 3,
    "baseColumnName": "publication_title",
    "expression": "\"\"",
    "onError": "keep-original"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column publication_title to PublicationTitle",
    "oldColumnName": "publication_title",
    "newColumnName": "PublicationTitle"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column print_identifier to title.identifier.issn",
    "oldColumnName": "print_identifier",
    "newColumnName": "title.identifier.issn"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column online_identifier to title.identifier.eissn",
    "oldColumnName": "online_identifier",
    "newColumnName": "title.identifier.eissn"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column title_url to tipp.url",
    "oldColumnName": "title_url",
    "newColumnName": "tipp.url"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column date_first_issue_online to DateFirstPackageIssue",
    "oldColumnName": "date_first_issue_online",
    "newColumnName": "DateFirstPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column date_last_issue_online to DateLastPackageIssue",
    "oldColumnName": "date_last_issue_online",
    "newColumnName": "DateLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column num_first_vol_online to VolumeFirstPackageIssue",
    "oldColumnName": "num_first_vol_online",
    "newColumnName": "VolumeFirstPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column num_first_issue_online to NumberFirstPackageIssue",
    "oldColumnName": "num_first_issue_online",
    "newColumnName": "NumberFirstPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column num_last_vol_online to VolumeLastPackageIssue",
    "oldColumnName": "num_last_vol_online",
    "newColumnName": "VolumeLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column num_last_issue_online to NumberLastPackageIssue",
    "oldColumnName": "num_last_issue_online",
    "newColumnName": "NumberLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column coverage_depth to CoverageDepth",
    "oldColumnName": "coverage_depth",
    "newColumnName": "CoverageDepth"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column publisher_name to title.imprint",
    "oldColumnName": "publisher_name",
    "newColumnName": "title.imprint"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==4,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:if(length(value)==4,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==7,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:if(length(value)==7,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==8,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:if(length(value)==8,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==9,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:if(length(value)==9,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:if(length(value)==10,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:if(length(value)==10,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==4,(inc(inc(toDate(toString(value)),1,\"year\"),-1,\"day\")),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==4,(inc(inc(toDate(toString(value)),1,\"year\"),-1,\"day\")),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==7,(inc(inc(toDate(value),1,\"month\"),-1,\"day\")),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==7,(inc(inc(toDate(value),1,\"month\"),-1,\"day\")),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==8,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==8,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==9,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==9,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==10,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==10,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column platform.host.name using expression grel:replace(value,\"\",\"American Society of Civil Engineers::{Platform:241910}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "platform.host.name",
    "expression": "grel:replace(value,\"\",\"American Society of Civil Engineers::{Platform:241910}\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column org.publisher.name using expression grel:replace(value,\"\",\"American Society of Civil Engineers::{Org:1935}\")value",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "org.publisher.name",
    "expression": "grel:replace(value,\"\",\"American Society of Civil Engineers::{Org:1935}\")value",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"American Society of Civil Engineers\",\"American Society of Civil Engineers::{Imprint:310729}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"American Society of Civil Engineers\",\"American Society of Civil Engineers::{Imprint:310729}\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column title.imprint using expression grel:replace(value, \"Research Institute of Highway, Ministry of Transport, Beijing (RIOH)\", \"Research Institute of Highway, Ministry of Transport, Beijing (RIOH)::{Imprint:310743}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value, \"Research Institute of Highway, Ministry of Transport, Beijing (RIOH)\", \"Research Institute of Highway, Ministry of Transport, Beijing (RIOH)::{Imprint:310743}\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
]