Page Comparison

Macro_American Institute of Physics Full Conversion MacroAmericanInstituteofPhysics_ScitationJournals.txt

[
  {
    "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-

...

addition",
    "description": "

...

Create column title.identifier.doi at index 4 based on column publication_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

...

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/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:replace(value,\".0\", \"\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:replace(value, \".0\", \"\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateFirstPackageIssue using expression grel:replace(value,\"Coming in \",\"\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateFirstPackageIssue",
    "expression": "grel:replace(value,\"

...

Coming in \",\"\")",
    "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

...

)==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

...

package.name using expression grel:

...

replace(value

...

,\"\",\"American Institute of Physics: Scitation Titles::{Package:248137}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "

...

package.name",
    "expression": "grel:

...

replace(value

...

,\"\",\"American Institute of Physics: Scitation Titles::{Package:248137}\")",
    "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,\"\",\"AIP Scitation::{Platform:67239}\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "platform.host.name",
    "expression": "grel:replace(value,\"\",\"AIP Scitation::{Platform:67239}\")",
    "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 Institute of Physics::{Org:1444}\")value",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "org.publisher.name",
    "expression": "grel:replace(value,\"\",\"American Institute of Physics::{Org:1444}\")value",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column CoverageDepth using expression grel:replace(value,\"full text\",\"fulltext\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "CoverageDepth",
    "expression": "grel:replace(value,\"full text\",\"fulltext\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column tipp.url using expression grel:replace(value, \" \", \"\")",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "tipp.url",
    "expression": "grel:replace(value, \" \", \"\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
]