Macro_AmericanChemicalSociety_AmericanChemicalSociety_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-rename",
"description": "Rename column title to PublicationTitle",
"oldColumnName": "title",
"newColumnName": "PublicationTitle"
},
{
"op": "core/column-rename",
"description": "Rename column issn to title.identifier.issn",
"oldColumnName": "issn",
"newColumnName": "title.identifier.issn"
},
{
"op": "core/column-rename",
"description": "Rename column e_issn to title.identifier.eissn",
"oldColumnName": "e_issn",
"newColumnName": "title.identifier.eissn"
},
{
"op": "core/column-rename",
"description": "Rename column journal_url to tipp.url",
"oldColumnName": "journal_url",
"newColumnName": "tipp.url"
},
{
"op": "core/column-rename",
"description": "Rename column ft_start_date to DateFirstPackageIssue",
"oldColumnName": "ft_start_date",
"newColumnName": "DateFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column ft_end_date to DateLastPackageIssue",
"oldColumnName": "ft_end_date",
"newColumnName": "DateLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column vol_ft_start to VolumeFirstPackageIssue",
"oldColumnName": "vol_ft_start",
"newColumnName": "VolumeFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column vol_ft_end to VolumeLastPackageIssue",
"oldColumnName": "vol_ft_end",
"newColumnName": "VolumeLastPackageIssue"
},
{
"op": "core/column-rename",
"description": "Rename column iss_ft_start to NumberFirstPackageIssue",
"oldColumnName": "iss_ft_start",
"newColumnName": "NumberFirstPackageIssue"
},
{
"op": "core/column-rename",
"description": "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/column-rename",
"description": "Rename column db_identifier to title.identifier.doi",
"oldColumnName": "db_identifier",
"newColumnName": "title.identifier.doi"
},
{
"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.eissn",
"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 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)==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)==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 Chemical Society: American Chemical Society::{Package:244206}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "package.name",
"expression": "grel:replace(value,\"\",\"American Chemical Society: American Chemical Society::{Package:244206}\")",
"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 Chemical Society::{Platform:241890}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "platform.host.name",
"expression": "grel:replace(value,\"\",\"American Chemical Society::{Platform:241890}\")",
"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 Chemical Society::{Org:1042}\")value",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "org.publisher.name",
"expression": "grel:replace(value,\"\",\"American Chemical Society::{Org:1042}\")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 Chemical Society\",\"American Chemical Society::{Imprint:244205}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"American Chemical Society\",\"American Chemical Society::{Imprint:244205}\")",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
]