Macro_AmericanMathematicalSociety_AmericanMathematicalSociety_CUFTS.txt
[
{
"op": "core/column-addition",
"description": "Create column platform.host.name at index 1 based on column title using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "platform.host.name",
"columnInsertIndex": 1,
"baseColumnName": "title",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/column-addition",
"description": "Create column package.name at index 2 based on column title using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "package.name",
"columnInsertIndex": 2,
"baseColumnName": "title",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/column-addition",
"description": "Create column org.publisher.name at index 3 based on column title using expression \"\"",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"newColumnName": "org.publisher.name",
"columnInsertIndex": 3,
"baseColumnName": "title",
"expression": "\"\"",
"onError": "keep-original"
},
{
"op": "core/column-renameaddition",
"description": "Rename column title to PublicationTitleCreate column title.identifier.doi at index 4 based on column title using expression \"\"",
"oldColumnNameengineConfig": {
"mode": "titlerow-based",
"newColumnNamefacets": "PublicationTitle"
[]
},
{
"opnewColumnName": "core/column-rename"title.identifier.doi",
"columnInsertIndex": 4,
"descriptionbaseColumnName": "Rename column issn to title.identifier.issn",
"oldColumnNameexpression": "issn\"\"",
"newColumnNameonError": "title.identifier.issnkeep-original"
},
{
"op": "core/column-rename",
"description": "Rename column e_issn to title.identifier.eissntitle to PublicationTitle",
"oldColumnName": "e_issntitle",
"newColumnName": "title.identifier.eissnPublicationTitle"
},
{
"op": "core/column-rename",
"description": "Rename column journal_url issn to tipptitle.urlidentifier.issn",
"oldColumnName": "journal_urlissn",
"newColumnName": "tipptitle.identifier.urlissn"
},
{
"op": "core/column-rename",
"description": "Rename column fte_start_date to DateFirstPackageIssueissn to title.identifier.eissn",
"oldColumnName": "fte_start_dateissn",
"newColumnName": "DateFirstPackageIssuetitle.identifier.eissn"
},
{
"op": "core/column-rename",
"description": "Rename column ftjournal_end_date to DateLastPackageIssueurl to tipp.url",
"oldColumnName": "ftjournal_end_dateurl",
"newColumnName": "DateLastPackageIssuetipp.url"
},
{
"op": "core/column-rename",
"description": "Rename column vol_ ft_start_date to VolumeFirstPackageIssueDateFirstPackageIssue",
"oldColumnName": "vol_ft_start_date",
"newColumnName": "VolumeFirstPackageIssueDateFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column vol_ ft_end_date to VolumeLastPackageIssueDateLastPackageIssue",
"oldColumnName": "vol_ft_end_date",
"newColumnName": "VolumeLastPackageIssueDateLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column issvol_ft_start to NumberFirstPackageIssueVolumeFirstPackageIssue",
"oldColumnName": "issvol_ft_start",
"newColumnName": "NumberFirstPackageIssueVolumeFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column issvol_ft_end to NumberLastPackageIssueVolumeLastPackageIssue",
"oldColumnName": "issvol_ft_end",
"newColumnName": "NumberLastPackageIssueVolumeLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column publisher to title.imprintiss_ft_start to NumberFirstPackageIssue",
"oldColumnName": "publisheriss_ft_start",
"newColumnName": "title.imprintNumberFirstPackageIssue"
},
{
"op": "core/textcolumn-transformrename",
"description": "Text transform on cells in column title.identifier.issn Rename column iss_ft_end to NumberLastPackageIssue",
"oldColumnName": "iss_ft_end",
"newColumnName": "NumberLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column publisher to title.imprint",
"oldColumnName": "publisher",
"newColumnName": "title.imprint"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.identifier.issn using expression grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.identifier.issn",
"expression": "grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.identifier.eissn using expression grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.identifier.issneissn",
"expression": "grel:substring(value,0,4)+\"-\"+substring(value,4,8)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.identifier.eissn DateFirstPackageIssue using expression grel:substringif(length(value,0,4)+\"-\"+substring(value,4,8)==4,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.identifier.eissnDateFirstPackageIssue",
"expression": "grel:substringif(length(value,0,4)+\"-\"+substring(value,4,8)==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)==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)==710,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssue",
"expression": "grel:if(length(value)==710,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(valueif(length(value)==4,(inc(inc(toDate(toString(value)),1,\"year\"),-1,\"day\")),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateFirstPackageIssueDateLastPackageIssue",
"expression": "grel:if(length(value)==104,(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)==4,7,(inc(inc(toDate(value),1,\"month\"),-1,\"day\")),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==47,(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)==710,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"expression": "grel:if(length(value)==710,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(length(value)==10,toDate(value),valuereplace(value,\"\",\"American Mathematical Society: American Mathematical Society::{Package:244222}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssuepackage.name",
"expression": "grel:ifreplace(length(value)==10,toDate(value),value,\"\",\"American Mathematical Society: American Mathematical Society::{Package:244222}\")",
"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 Mathematical Society::{Platform:241891}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "platform.host.name",
"expression": "grel:replace(value,\"\",\"American Mathematical Society::{Platform:241891}\")",
"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 Mathematical Society::{Org:1516}\")value",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "org.publisher.name",
"expression": "grel:replace(value,\"\",\"American Mathematical Society::{Org:1516}\")value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"American Mathematical Society\",\"American Mathematical::{Imprint:244211}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"American Mathematical Society\",\"American Mathematical Society::{Imprint:244211}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"Brown University\",\"Brown University::{Imprint:244212}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"Brown University\",\"Brown University::{Imprint:244212}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"Independent University of Moscow\",\"Independent University of Moscow::{Imprint:244213}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"Independent University of Moscow\",\"Independent University of Moscow::{Imprint:244213}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"Kiev University\",\"Kiev University::{Imprint:244214}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"Kiev University\",\"Kiev University::{Imprint:244214}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"Moscow Mathematical Society\",\"Moscow Mathematical Society::{Imprint:244215}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"Moscow Mathematical Society\",\"Moscow Mathematical Society::{Imprint:244215}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"Ramanujan Mathematical Society\",\"Ramanujan Mathematical Society::{Imprint:244216}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"Ramanujan Mathematical Society\",\"Ramanujan Mathematical Society::{Imprint:244216}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"Russian Academy of Sciences\",\"Russian Academy of Sciences::{Imprint:244217}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"Russian Academy of Sciences\",\"Russian Academy of Sciences::{Imprint:244217}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"Theta Foundation\",\"Theta Foundation::{Imprint:244218}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"Theta Foundation\",\"Theta Foundation::{Imprint:244218}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column title.imprint using expression grel:replace(value,\"University Press Inc.\",\"University Press Inc.::{Imprint:244219}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"University Press Inc.\",\"University Press Inc.::{Imprint:244219}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
]