[Macro_BMJPublishingGroup_BMJOnline_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 PublicationTitle",
"oldColumnName": "title",
"newColumnName": "PublicationTitle"
},
{
"op": "core/column-rename",
"description": "Rename column issn to title.identifier.issn",
"oldColumnName": "issn",
"newColumnName": "title.identifier.issn"
},
{
"op": "Create column title.identifier.doi at index 4 based on column title using expression \"\"", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "title.identifier.doi", "columnInsertIndex": 4, "baseColumnName": "title", "expression": "\"\"", "onError": "keep-original" }, { "op": "core/column-rename",
"description": "Rename column e_issn to title.identifier.eissntitle to PublicationTitle",
"oldColumnName": "e_issntitle",
"newColumnName": "title.identifier.eissn"
PublicationTitle" },
{
"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": "DateFirstPackageIssue"
title.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.imprint",
"iss_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 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
},
{
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.eissn issn 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,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"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 DateLastPackageIssue using expression grel:if(length(value)==7,toDate(value),value)",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "DateLastPackageIssue",
"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 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,\"\",\"BMJ Publications::{Platform:241892}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "platform.host.name",
"expression": "grel:replace(value,\"\",\"BMJ Publications::{Platform:241892}\")",
"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,\"\",\"BMJ Publishing Group::{Org:3207}\")value",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "org.publisher.name",
"expression": "grel:replace(value,\"\",\"BMJ Publishing Group::{Org:3207}\")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,\"BMJ Group\",\"BMJ Group::{Imprint:244227}\")",
"engineConfig": {
"mode": "row-based",
"facets": []
},
"columnName": "title.imprint",
"expression": "grel:replace(value,\"BMJ Group\",\"BMJ Group::{Imprint:244227}\")",
"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,\" http://www.bmj.com/the BMJ\",
[ { "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" ": [] }, "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.issn 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:substring(value,0,4)+\"-\"+substring(value,4,8": "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)==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(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)==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,toDate(value(value)==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,\"\",\"BMJ Publishing Group: BMJ Online::{Package:244228}\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "DateLastPackageIssuepackage.name", "expression": "grel:if(lengthreplace(value)==10,toDate(value),value,\"\",\"BMJ Publishing Group: BMJ Online::{Package:244228}\")", "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,\"\",\"BMJ Publications::{Platform:241892}\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "platform.host.name", "expression": "grel:replace(value,\"\",\"BMJ Publications::{Platform:241892}\")", "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,\"\",\"BMJ Publishing Group::{Org:3207}\")value", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "org.publisher.name", "expression": "grel:replace(value,\"\",\"BMJ Publishing Group::{Org:3207}\")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,\"BMJ Group\",\"BMJ Group::{Imprint:244227}\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "title.imprint", "expression": "grel:replace(value,\"BMJ Group\",\"BMJ Group::{Imprint:244227}\")", "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,\"http://www.bmj.com/the BMJ\",\"http://www.bmj.com/theBMJ\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "tipp.url", "expression": "grel:replace(value,\"http://www.bmj.com/the BMJ\",\"http://www.bmj.com/theBMJ\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 } ]