[
{
"op": "core/column-addition",
"description": "Create column text2 at index 1 based on column text using expression grel:value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "text2",
"columnInsertIndex": 1,
"baseColumnName": "text",
"expression": "grel:value",
"onError": "set-to-blank"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column text2 using expression value.trim()",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "text2",
"expression": "value.trim()",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column text2 using expression value.replace(/\\s+/,' ')",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "text2",
"expression": "value.replace(/\\s+/,' ')",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-split",
"description": "Split column text2 by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "text2",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": " ",
"regex": false,
"maxColumns": 0
},
{
"op": "core/column-move",
"description": "Move column id to position 0",
"columnName": "id",
"index": 0
},
{
"op": "core/column-move",
"description": "Move column from_user to position 0",
"columnName": "from_user",
"index": 0
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 28 into rows",
"startColumnName": "text2 28",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 27 into rows",
"startColumnName": "text2 27",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 26 into rows",
"startColumnName": "text2 26",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 25 into rows",
"startColumnName": "text2 25",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 24 into rows",
"startColumnName": "text2 24",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 23 into rows",
"startColumnName": "text2 23",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 22 into rows",
"startColumnName": "text2 22",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 21 into rows",
"startColumnName": "text2 21",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 20 into rows",
"startColumnName": "text2 20",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 19 into rows",
"startColumnName": "text2 19",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 18 into rows",
"startColumnName": "text2 18",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 17 into rows",
"startColumnName": "text2 17",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 16 into rows",
"startColumnName": "text2 16",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 15 into rows",
"startColumnName": "text2 15",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 14 into rows",
"startColumnName": "text2 14",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 13 into rows",
"startColumnName": "text2 13",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 12 into rows",
"startColumnName": "text2 12",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 11 into rows",
"startColumnName": "text2 11",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 10 into rows",
"startColumnName": "text2 10",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 9 into rows",
"startColumnName": "text2 9",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 8 into rows",
"startColumnName": "text2 8",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 7 into rows",
"startColumnName": "text2 7",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 6 into rows",
"startColumnName": "text2 6",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 5 into rows",
"startColumnName": "text2 5",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 4 into rows",
"startColumnName": "text2 4",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 3 into rows",
"startColumnName": "text2 3",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 2 into rows",
"startColumnName": "text2 2",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/transpose-columns-into-rows",
"description": "Transpose cells in 2 column(s) starting with text2 1 into rows",
"startColumnName": "text2 1",
"columnCount": 2,
"combinedColumnName": "",
"prependColumnName": false,
"separator": ":",
"ignoreBlankCells": true
},
{
"op": "core/column-addition",
"description": "Create column hastag at index 4 based on column text2 1 using expression grel:value",
"engineConfig": {
"facets": [
{
"query": "#",
"name": "text2 1",
"caseSensitive": false,
"columnName": "text2 1",
"type": "text",
"mode": "text"
}
],
"mode": "row-based"
},
"newColumnName": "hastag",
"columnInsertIndex": 4,
"baseColumnName": "text2 1",
"expression": "grel:value",
"onError": "set-to-blank"
},
{
"op": "core/column-addition",
"description": "Create column mention at index 4 based on column text2 1 using expression grel:value",
"engineConfig": {
"facets": [
{
"query": "@",
"name": "text2 1",
"caseSensitive": false,
"columnName": "text2 1",
"type": "text",
"mode": "text"
}
],
"mode": "row-based"
},
"newColumnName": "mention",
"columnInsertIndex": 4,
"baseColumnName": "text2 1",
"expression": "grel:value",
"onError": "set-to-blank"
},
{
"op": "core/column-removal",
"description": "Remove column text2 1",
"columnName": "text2 1"
},
{
"op": "core/row-star",
"description": "Star rows",
"engineConfig": {
"facets": [
{
"invert": false,
"expression": "isBlank(value)",
"selectError": false,
"omitError": false,
"selectBlank": false,
"name": "hastag",
"omitBlank": false,
"columnName": "hastag",
"type": "list",
"selection": [
{
"v": {
"v": false,
"l": "false"
}
}
]
}
],
"mode": "row-based"
},
"starred": true
},
{
"op": "core/row-star",
"description": "Star rows",
"engineConfig": {
"facets": [
{
"invert": false,
"expression": "isBlank(value)",
"selectError": false,
"omitError": false,
"selectBlank": false,
"name": "mention",
"omitBlank": false,
"columnName": "mention",
"type": "list",
"selection": [
{
"v": {
"v": false,
"l": "false"
}
}
]
}
],
"mode": "row-based"
},
"starred": true
},
{
"op": "core/row-star",
"description": "Star rows",
"engineConfig": {
"facets": [
{
"invert": false,
"expression": "isBlank(value)",
"selectError": false,
"omitError": false,
"selectBlank": false,
"name": "from_user",
"omitBlank": false,
"columnName": "from_user",
"type": "list",
"selection": [
{
"v": {
"v": false,
"l": "false"
}
}
]
}
],
"mode": "row-based"
},
"starred": true
},
{
"op": "core/row-removal",
"description": "Remove rows",
"engineConfig": {
"facets": [
{
"invert": false,
"expression": "row.starred",
"selectError": false,
"omitError": false,
"selectBlank": false,
"name": "Starred Rows",
"omitBlank": false,
"columnName": "",
"type": "list",
"selection": [
{
"v": {
"v": false,
"l": "false"
}
}
]
}
],
"mode": "row-based"
}
},
{
"op": "core/row-star",
"description": "Unstar rows",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"starred": false
}
]