Versions Compared

Key

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

Macro-CUFTS-AmericanMathematicalSociety_AmericanMathematicalSociety_AmericanMathematicalSociety_CUFTS.txt

[
  {
[ {     "op": "core/column-addition",
    "description": "Create column platform.host.name at index 1 based on column title using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "platform.host.name",
    "columnInsertIndex": 1,
    "baseColumnName": "title",
    "expression": "\"\"",
    "onError": "keep-original"
  },
  {
    "op": "core/column-addition",
    "description": "Create column package.name at index 2 based on column title using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "package.name",
    "columnInsertIndex": 2,
    "baseColumnName": "title",
    "expression": "\"\"",
    "onError": "keep-original"
  },
  {
    "op": "core/column-addition",
    "description": "Create column org.publisher.name at index 3 based on column title using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "org.publisher.name",
    "columnInsertIndex": 3,
    "baseColumnName": "title",
    "expression": "\"\"",
    "onError": "keep-original"
  },
  {
    "op": "core/column-renameaddition",
    "description": "Rename column title to PublicationTitle", "oldColumnName": "title", "newColumnName": "PublicationTitle" }, { "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 e_issn to title.identifier.eissn", "oldColumnName": "e_issn", "newColumnName": "title.identifier.eissn" }, { Create column title.identifier.doi at index 4 based on column title using expression \"\"",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "title.identifier.doi",
    "columnInsertIndex": 4,
    "baseColumnName": "title",
    "expression": "\"\"",
    "onError": "keep-original"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column journal_url to tipp.urltitle to PublicationTitle",
    "oldColumnName": "journal_urltitle",
    "newColumnName": "tipp.urlPublicationTitle"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column ft_start_date to DateFirstPackageIssueissn to title.identifier.issn",
    "oldColumnName": "ft_start_dateissn",
    "newColumnName": "DateFirstPackageIssue" title.identifier.issn"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column fte_end_date to DateLastPackageIssueissn to title.identifier.eissn",
    "oldColumnName": "fte_end_dateissn",
    "newColumnName": "DateLastPackageIssue" title.identifier.eissn"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column voljournal_ft_start to VolumeFirstPackageIssueurl to tipp.url",
    "oldColumnName": "voljournal_ft_starturl",
    "newColumnName": "VolumeFirstPackageIssuetipp.url"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column volft_ftstart_end date to VolumeLastPackageIssueDateFirstPackageIssue",
    "oldColumnName": "volft_ftstart_enddate",
    "newColumnName": "VolumeLastPackageIssueDateFirstPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column issft_ftend_start date to NumberFirstPackageIssueDateLastPackageIssue",
    "oldColumnName": "issft_ftend_startdate",
    "newColumnName": "NumberFirstPackageIssueDateLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column issvol_ft_end start to NumberLastPackageIssueVolumeFirstPackageIssue",
    "oldColumnName": "issvol_ft_endstart",
    "newColumnName": "NumberLastPackageIssueVolumeFirstPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column publisher to title.imprint", "oldColumnName": "publisher", "newColumnName": "title.imprint" }, { vol_ft_end to VolumeLastPackageIssue",
    "oldColumnName": "vol_ft_end",
    "newColumnName": "VolumeLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column iss_ft_start to NumberFirstPackageIssue",
    "oldColumnName": "iss_ft_start",
    "newColumnName": "NumberFirstPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column iss_ft_end to NumberLastPackageIssue",
    "oldColumnName": "iss_ft_end",
    "newColumnName": "NumberLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column publisher to title.imprint",
    "oldColumnName": "publisher",
    "newColumnName": "title.imprint"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column title.identifier.issn using expression grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.identifier.issn",
    "expression": "grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column title.identifier.issn eissn using expression grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.identifier.issneissn",
    "expression": "grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column title.identifier.eissn DateFirstPackageIssue using expression grel:substringif(length(value,0,4)+\"-\"+substring(value,4,8)==4,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.identifier.eissnDateFirstPackageIssue",
    "expression": "grel:substring(value,0,4)+\"-\"+substring(value,4,8)", ": "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)==47,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:if(length(value)==47,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)==710,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:if(length(value)==710,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue DateLastPackageIssue using expression grel:if(length(value)==104,toDate(value(inc(inc(toDate(toString(value)),1,\"year\"),-1,\"day\")),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssueDateLastPackageIssue",
    "expression": "grel:if(length(value)==104,(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)==47,(inc(inc(toDate(toString(value)),1,\"yearmonth\"),-1,\"day\")),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==47,(inc(inc(toDate(toString(value)),1,\"yearmonth\"),-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\"))==10,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==710,(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 package.name using expression grel:ifreplace(length(value)==10,toDate(value),value,\"\",\"American Mathematical Society: American Mathematical Society::{Package:244222}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssuepackage.name",
    "expression": "grel:if(length(value)==10,toDate(value),value)", replace(value,\"\",\"American Mathematical Society: American Mathematical Society::{Package:244222}\")",
    "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 Mathematical Society::{Platform:241891}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "platform.host.name",
    "expression": "grel:replace(value,\"\",\"American Mathematical Society::{Platform:241891}\")",
    "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 Mathematical Society::{Org:1516}\")value",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "org.publisher.name",
    "expression": "grel:replace(value,\"\",\"American Mathematical Society::{Org:1516}\")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 Mathematical Society\",\"American Mathematical::{Imprint:244211}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"American Mathematical Society\",\"American Mathematical Society::{Imprint:244211}\")",
    "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,\"Brown University\",\"Brown University::{Imprint:244212}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint", ,
    "expression": "grel:replace(value,\"Brown University\",\"Brown University::{Imprint:244212}\")",
    "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,\"Independent University of Moscow\",\"Independent University of Moscow::{Imprint:244213}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"Independent University of Moscow\",\"Independent University of Moscow::{Imprint:244213}\")",
    "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,\"Kiev University\",\"Kiev University::{Imprint:244214}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"Kiev University\",\"Kiev University::{Imprint:244214}\")",
    "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,\"Moscow Mathematical Society\",\"Moscow Mathematical Society::{Imprint:244215}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"Moscow Mathematical Society\",\"Moscow Mathematical Society::{Imprint:244215}\")",
    "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,\"Ramanujan Mathematical Society\",\"Ramanujan Mathematical Society::{Imprint:244216}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"Ramanujan Mathematical Society\",\"Ramanujan Mathematical Society::{Imprint:244216}\")",
    "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,\"Russian Academy of Sciences\",\"Russian Academy of Sciences::{Imprint:244217}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    }, ,
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"Russian Academy of Sciences\",\"Russian Academy of Sciences::{Imprint:244217}\")",
    "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,\"Theta Foundation\",\"Theta Foundation::{Imprint:244218}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"Theta Foundation\",\"Theta Foundation::{Imprint:244218}\")",
    "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,\"University Press Inc.\",\"University Press Inc.::{Imprint:244219}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "title.imprint",
    "expression": "grel:replace(value,\"University Press Inc.\",\"University Press Inc.::{Imprint:244219}\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
]