American Society of Civil Engineers Full Conversion Macro
[...
{ "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/
...
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
...
} ]