American Society of Civil Engineers Full Conversion Macro
...
Macro_AmericanSocietyofCivilEngineers_Journals.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-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 title_id to title.identifier.doi",
"oldColumnName": "title_id",
"newColumnName": "title.identifier.doi"
},
{
"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)==
...
...
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
...
},
...
"columnName":
...
"DateFirstPackageIssue",
...
"expression":
...
...
...
"onError":
...
"keep-original",
...
"repeat":
...
false,
...
"repeatCount":
...
10
...
},
...
{
"op":
...
"core/text-transform",
...
"description":
...
"Text
...
transform
...
on
...
cells
...
in
...
column
...
DateFirstPackageIssue
...
using
...
expression
...
...
...
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
},
"columnName":
...
"DateFirstPackageIssue",
...
"expression":
...
...
...
"onError":
...
"keep-original",
...
"repeat":
...
false,
...
"repeatCount":
...
10
...
},
...
{
"op":
...
"core/text-transform",
...
"description":
...
"Text
...
transform
...
on
...
cells
...
in
...
column
...
DateFirstPackageIssue
...
using
...
expression
...
...
...
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
...
},
...
"columnName":
...
"DateFirstPackageIssue",
...
"expression":
...
...
...
"onError":
...
"keep-original",
...
"repeat":
...
false,
...
"repeatCount":
...
10
...
},
...
{
"op":
...
"core/text-transform",
...
"description":
...
"Text
...
transform
...
on
...
cells
...
in
...
column
...
DateFirstPackageIssue
...
using
...
expression
...
...
...
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
...
},
...
"columnName":
...
"DateFirstPackageIssue",
...
"expression":
...
...
...
"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
...
...
...
...
...
value)",
...
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
...
},
...
"columnName":
...
"DateLastPackageIssue",
...
"expression":
...
...
...
...
...
value)",
...
"onError":
...
"keep-original",
...
"repeat":
...
false,
...
"repeatCount":
...
10
...
},
...
{
"op":
...
"core/text-transform",
...
"description":
...
"Text
...
transform
...
on
...
cells
...
in
...
column
...
DateLastPackageIssue
...
using
...
expression
...
...
...
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
...
},
...
"columnName":
...
"DateLastPackageIssue",
...
"expression":
...
...
...
"onError":
...
"keep-original",
...
"repeat":
...
false,
...
"repeatCount":
...
10
...
},
...
{
"op":
...
"core/text-transform",
...
"description":
...
"Text
...
transform
...
on
...
cells
...
in
...
column
...
DateLastPackageIssue
...
using
...
expression
...
...
...
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
...
},
...
"columnName":
...
"DateLastPackageIssue",
...
"expression":
...
...
...
"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 Society of Civil Engineers: Journals::{Package:310462}\")",
"engineConfig":
...
{
"mode":
...
"row-based",
...
"facets":
...
[]
...
},
...
"columnName":
...
"
...
package.name",
...
"expression":
...
...
replace(value
...
,\"\",\"American Society of Civil Engineers: Journals::{Package:310462}\")",
"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
...
}
]