American Society of Mechanical Engineers Full Conversion Macro
Macro_AmericanSocietyofMechanicalEngineers_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-renameaddition",
"description": "Rename Create column title.identifier.doi at index 4 based on column publication_title to PublicationTitleusing expression \"\"",
"oldColumnNameengineConfig": "publication_title",
"newColumnName{
"mode": "PublicationTitle"
},
{row-based",
"facets": []
},
"opnewColumnName": "core/column-rename"title.identifier.doi",
"columnInsertIndex": 4,
"descriptionbaseColumnName": "Rename column print_identifier to title.identifier.issn",
"oldColumnNameexpression": "print_identifier"\"\"",
"newColumnNameonError": "title.identifier.issnkeep-original"
},
{
"op": "core/column-rename",
"description": "Rename column onlinepublication_identifier to title.identifier.eissntitle to PublicationTitle",
"oldColumnName": "onlinepublication_identifiertitle",
"newColumnName": "title.identifier.eissnPublicationTitle"
},
{
"op": "core/column-rename",
"description": "Rename column titleprint_url identifier to tipptitle.identifier.urlissn",
"oldColumnName": "titleprint_urlidentifier",
"newColumnName": "tipptitle.identifier.urlissn"
},
{
"op": "core/column-rename",
"description": "Rename column date_first_issue_online to DateFirstPackageIssueonline_identifier to title.identifier.eissn",
"oldColumnName": "date_first_issue_onlineonline_identifier",
"newColumnName": "DateFirstPackageIssuetitle.identifier.eissn"
},
{
"op": "core/column-rename",
"description": "Rename column date_last_issue_online to DateLastPackageIssuetitle_url to tipp.url",
"oldColumnName": "date_last_issue_onlinetitle_url",
"newColumnName": "DateLastPackageIssuetipp.url"
},
{
"op": "core/column-rename",
"description": "Rename column numdate_first_volissue_online to VolumeFirstPackageIssueDateFirstPackageIssue",
"oldColumnName": "numdate_first_volissue_online",
"newColumnName": "VolumeFirstPackageIssueDateFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column numdate_firstlast_issue_online to NumberFirstPackageIssueDateLastPackageIssue",
"oldColumnName": "numdate_firstlast_issue_online",
"newColumnName": "NumberFirstPackageIssueDateLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column num_lastfirst_vol_online to VolumeLastPackageIssueVolumeFirstPackageIssue",
"oldColumnName": "num_lastfirst_vol_online",
"newColumnName": "VolumeLastPackageIssueVolumeFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column num_lastfirst_issue_online to NumberLastPackageIssueNumberFirstPackageIssue",
"oldColumnName": "num_lastfirst_issue_online",
"newColumnName": "NumberLastPackageIssueNumberFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column coverage_depth to CoverageDepthnum_last_vol_online to VolumeLastPackageIssue",
"oldColumnName": "coverage_depthnum_last_vol_online",
"newColumnName": "CoverageDepthVolumeLastPackageIssue"
},
{
"op": "core/textcolumn-transformrename",
"description": "Text transform on cells in column DateFirstPackageIssue using expression grel:replace(value, \".0\", 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,\".0Coming in \",\"\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column DateFirstPackageIssue using expression grel:replaceif(length(value,\"Coming in \",\"\")==4,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssue",
"expression": "grel:replacegrel:if(length(value)==4,toDate(value,\"Coming in \",\"\"),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)==78,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssue",
"expression": "grel:if(length(value)==78,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)==89,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssue",
"expression": "grel:if(length(value)==89,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)==910,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssue",
"expression": "grel:if(length(value)==910,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)==10,toDate(value(value)==4,(inc(inc(toDate(toString(value)),1,\"year\"),-1,\"day\")),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssueDateLastPackageIssue",
"expression": "grel:if(length(value)==10,toDate(value"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)==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\"))==8,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==78,(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)==89,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==89,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)==910,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==910,toDate(value),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:if(lengthreplace(value)==10,toDate(value),value,\"\",\"American Society of Mechanical Engineers: Journals::{Package:345231}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssuepackage.name",
"expression": "grel:if(lengthreplace(value)==10,toDate(value),value,\"\",\"American Society of Mechanical Engineers: Journals::{Package:345231}\")",
"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 Mechanical Engineers::{Platform:241911}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "platform.host.name",
"expression": "grel:replace(value,\"\",\"American Society of Mechanical Engineers::{Platform:241911}\")",
"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 Mechanical Engineers::{Org:2027}\")value",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "org.publisher.name",
"expression": "grel:replace(value,\"\",\"American Society of Mechanical Engineers::{Org:2027}\")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
}
]