Macro_AmericanInstituteofPhysics_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:
...
...
)==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
...
...
)==8,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(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
}
]