Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. [
  2. {
  3. "op": "core/column-addition",
  4. "description": "Create column text2 at index 1 based on column text using expression grel:value",
  5. "engineConfig": {
  6. "facets": [],
  7. "mode": "row-based"
  8. },
  9. "newColumnName": "text2",
  10. "columnInsertIndex": 1,
  11. "baseColumnName": "text",
  12. "expression": "grel:value",
  13. "onError": "set-to-blank"
  14. },
  15. {
  16. "op": "core/text-transform",
  17. "description": "Text transform on cells in column text2 using expression value.trim()",
  18. "engineConfig": {
  19. "facets": [],
  20. "mode": "row-based"
  21. },
  22. "columnName": "text2",
  23. "expression": "value.trim()",
  24. "onError": "keep-original",
  25. "repeat": false,
  26. "repeatCount": 10
  27. },
  28. {
  29. "op": "core/text-transform",
  30. "description": "Text transform on cells in column text2 using expression value.replace(/\\s+/,' ')",
  31. "engineConfig": {
  32. "facets": [],
  33. "mode": "row-based"
  34. },
  35. "columnName": "text2",
  36. "expression": "value.replace(/\\s+/,' ')",
  37. "onError": "keep-original",
  38. "repeat": false,
  39. "repeatCount": 10
  40. },
  41. {
  42. "op": "core/column-split",
  43. "description": "Split column text2 by separator",
  44. "engineConfig": {
  45. "facets": [],
  46. "mode": "row-based"
  47. },
  48. "columnName": "text2",
  49. "guessCellType": true,
  50. "removeOriginalColumn": true,
  51. "mode": "separator",
  52. "separator": " ",
  53. "regex": false,
  54. "maxColumns": 0
  55. },
  56. {
  57. "op": "core/column-move",
  58. "description": "Move column id to position 0",
  59. "columnName": "id",
  60. "index": 0
  61. },
  62. {
  63. "op": "core/column-move",
  64. "description": "Move column from_user to position 0",
  65. "columnName": "from_user",
  66. "index": 0
  67. },
  68. {
  69. "op": "core/transpose-columns-into-rows",
  70. "description": "Transpose cells in 2 column(s) starting with text2 28 into rows",
  71. "startColumnName": "text2 28",
  72. "columnCount": 2,
  73. "combinedColumnName": "",
  74. "prependColumnName": false,
  75. "separator": ":",
  76. "ignoreBlankCells": true
  77. },
  78. {
  79. "op": "core/transpose-columns-into-rows",
  80. "description": "Transpose cells in 2 column(s) starting with text2 27 into rows",
  81. "startColumnName": "text2 27",
  82. "columnCount": 2,
  83. "combinedColumnName": "",
  84. "prependColumnName": false,
  85. "separator": ":",
  86. "ignoreBlankCells": true
  87. },
  88. {
  89. "op": "core/transpose-columns-into-rows",
  90. "description": "Transpose cells in 2 column(s) starting with text2 26 into rows",
  91. "startColumnName": "text2 26",
  92. "columnCount": 2,
  93. "combinedColumnName": "",
  94. "prependColumnName": false,
  95. "separator": ":",
  96. "ignoreBlankCells": true
  97. },
  98. {
  99. "op": "core/transpose-columns-into-rows",
  100. "description": "Transpose cells in 2 column(s) starting with text2 25 into rows",
  101. "startColumnName": "text2 25",
  102. "columnCount": 2,
  103. "combinedColumnName": "",
  104. "prependColumnName": false,
  105. "separator": ":",
  106. "ignoreBlankCells": true
  107. },
  108. {
  109. "op": "core/transpose-columns-into-rows",
  110. "description": "Transpose cells in 2 column(s) starting with text2 24 into rows",
  111. "startColumnName": "text2 24",
  112. "columnCount": 2,
  113. "combinedColumnName": "",
  114. "prependColumnName": false,
  115. "separator": ":",
  116. "ignoreBlankCells": true
  117. },
  118. {
  119. "op": "core/transpose-columns-into-rows",
  120. "description": "Transpose cells in 2 column(s) starting with text2 23 into rows",
  121. "startColumnName": "text2 23",
  122. "columnCount": 2,
  123. "combinedColumnName": "",
  124. "prependColumnName": false,
  125. "separator": ":",
  126. "ignoreBlankCells": true
  127. },
  128. {
  129. "op": "core/transpose-columns-into-rows",
  130. "description": "Transpose cells in 2 column(s) starting with text2 22 into rows",
  131. "startColumnName": "text2 22",
  132. "columnCount": 2,
  133. "combinedColumnName": "",
  134. "prependColumnName": false,
  135. "separator": ":",
  136. "ignoreBlankCells": true
  137. },
  138. {
  139. "op": "core/transpose-columns-into-rows",
  140. "description": "Transpose cells in 2 column(s) starting with text2 21 into rows",
  141. "startColumnName": "text2 21",
  142. "columnCount": 2,
  143. "combinedColumnName": "",
  144. "prependColumnName": false,
  145. "separator": ":",
  146. "ignoreBlankCells": true
  147. },
  148. {
  149. "op": "core/transpose-columns-into-rows",
  150. "description": "Transpose cells in 2 column(s) starting with text2 20 into rows",
  151. "startColumnName": "text2 20",
  152. "columnCount": 2,
  153. "combinedColumnName": "",
  154. "prependColumnName": false,
  155. "separator": ":",
  156. "ignoreBlankCells": true
  157. },
  158. {
  159. "op": "core/transpose-columns-into-rows",
  160. "description": "Transpose cells in 2 column(s) starting with text2 19 into rows",
  161. "startColumnName": "text2 19",
  162. "columnCount": 2,
  163. "combinedColumnName": "",
  164. "prependColumnName": false,
  165. "separator": ":",
  166. "ignoreBlankCells": true
  167. },
  168. {
  169. "op": "core/transpose-columns-into-rows",
  170. "description": "Transpose cells in 2 column(s) starting with text2 18 into rows",
  171. "startColumnName": "text2 18",
  172. "columnCount": 2,
  173. "combinedColumnName": "",
  174. "prependColumnName": false,
  175. "separator": ":",
  176. "ignoreBlankCells": true
  177. },
  178. {
  179. "op": "core/transpose-columns-into-rows",
  180. "description": "Transpose cells in 2 column(s) starting with text2 17 into rows",
  181. "startColumnName": "text2 17",
  182. "columnCount": 2,
  183. "combinedColumnName": "",
  184. "prependColumnName": false,
  185. "separator": ":",
  186. "ignoreBlankCells": true
  187. },
  188. {
  189. "op": "core/transpose-columns-into-rows",
  190. "description": "Transpose cells in 2 column(s) starting with text2 16 into rows",
  191. "startColumnName": "text2 16",
  192. "columnCount": 2,
  193. "combinedColumnName": "",
  194. "prependColumnName": false,
  195. "separator": ":",
  196. "ignoreBlankCells": true
  197. },
  198. {
  199. "op": "core/transpose-columns-into-rows",
  200. "description": "Transpose cells in 2 column(s) starting with text2 15 into rows",
  201. "startColumnName": "text2 15",
  202. "columnCount": 2,
  203. "combinedColumnName": "",
  204. "prependColumnName": false,
  205. "separator": ":",
  206. "ignoreBlankCells": true
  207. },
  208. {
  209. "op": "core/transpose-columns-into-rows",
  210. "description": "Transpose cells in 2 column(s) starting with text2 14 into rows",
  211. "startColumnName": "text2 14",
  212. "columnCount": 2,
  213. "combinedColumnName": "",
  214. "prependColumnName": false,
  215. "separator": ":",
  216. "ignoreBlankCells": true
  217. },
  218. {
  219. "op": "core/transpose-columns-into-rows",
  220. "description": "Transpose cells in 2 column(s) starting with text2 13 into rows",
  221. "startColumnName": "text2 13",
  222. "columnCount": 2,
  223. "combinedColumnName": "",
  224. "prependColumnName": false,
  225. "separator": ":",
  226. "ignoreBlankCells": true
  227. },
  228. {
  229. "op": "core/transpose-columns-into-rows",
  230. "description": "Transpose cells in 2 column(s) starting with text2 12 into rows",
  231. "startColumnName": "text2 12",
  232. "columnCount": 2,
  233. "combinedColumnName": "",
  234. "prependColumnName": false,
  235. "separator": ":",
  236. "ignoreBlankCells": true
  237. },
  238. {
  239. "op": "core/transpose-columns-into-rows",
  240. "description": "Transpose cells in 2 column(s) starting with text2 11 into rows",
  241. "startColumnName": "text2 11",
  242. "columnCount": 2,
  243. "combinedColumnName": "",
  244. "prependColumnName": false,
  245. "separator": ":",
  246. "ignoreBlankCells": true
  247. },
  248. {
  249. "op": "core/transpose-columns-into-rows",
  250. "description": "Transpose cells in 2 column(s) starting with text2 10 into rows",
  251. "startColumnName": "text2 10",
  252. "columnCount": 2,
  253. "combinedColumnName": "",
  254. "prependColumnName": false,
  255. "separator": ":",
  256. "ignoreBlankCells": true
  257. },
  258. {
  259. "op": "core/transpose-columns-into-rows",
  260. "description": "Transpose cells in 2 column(s) starting with text2 9 into rows",
  261. "startColumnName": "text2 9",
  262. "columnCount": 2,
  263. "combinedColumnName": "",
  264. "prependColumnName": false,
  265. "separator": ":",
  266. "ignoreBlankCells": true
  267. },
  268. {
  269. "op": "core/transpose-columns-into-rows",
  270. "description": "Transpose cells in 2 column(s) starting with text2 8 into rows",
  271. "startColumnName": "text2 8",
  272. "columnCount": 2,
  273. "combinedColumnName": "",
  274. "prependColumnName": false,
  275. "separator": ":",
  276. "ignoreBlankCells": true
  277. },
  278. {
  279. "op": "core/transpose-columns-into-rows",
  280. "description": "Transpose cells in 2 column(s) starting with text2 7 into rows",
  281. "startColumnName": "text2 7",
  282. "columnCount": 2,
  283. "combinedColumnName": "",
  284. "prependColumnName": false,
  285. "separator": ":",
  286. "ignoreBlankCells": true
  287. },
  288. {
  289. "op": "core/transpose-columns-into-rows",
  290. "description": "Transpose cells in 2 column(s) starting with text2 6 into rows",
  291. "startColumnName": "text2 6",
  292. "columnCount": 2,
  293. "combinedColumnName": "",
  294. "prependColumnName": false,
  295. "separator": ":",
  296. "ignoreBlankCells": true
  297. },
  298. {
  299. "op": "core/transpose-columns-into-rows",
  300. "description": "Transpose cells in 2 column(s) starting with text2 5 into rows",
  301. "startColumnName": "text2 5",
  302. "columnCount": 2,
  303. "combinedColumnName": "",
  304. "prependColumnName": false,
  305. "separator": ":",
  306. "ignoreBlankCells": true
  307. },
  308. {
  309. "op": "core/transpose-columns-into-rows",
  310. "description": "Transpose cells in 2 column(s) starting with text2 4 into rows",
  311. "startColumnName": "text2 4",
  312. "columnCount": 2,
  313. "combinedColumnName": "",
  314. "prependColumnName": false,
  315. "separator": ":",
  316. "ignoreBlankCells": true
  317. },
  318. {
  319. "op": "core/transpose-columns-into-rows",
  320. "description": "Transpose cells in 2 column(s) starting with text2 3 into rows",
  321. "startColumnName": "text2 3",
  322. "columnCount": 2,
  323. "combinedColumnName": "",
  324. "prependColumnName": false,
  325. "separator": ":",
  326. "ignoreBlankCells": true
  327. },
  328. {
  329. "op": "core/transpose-columns-into-rows",
  330. "description": "Transpose cells in 2 column(s) starting with text2 2 into rows",
  331. "startColumnName": "text2 2",
  332. "columnCount": 2,
  333. "combinedColumnName": "",
  334. "prependColumnName": false,
  335. "separator": ":",
  336. "ignoreBlankCells": true
  337. },
  338. {
  339. "op": "core/transpose-columns-into-rows",
  340. "description": "Transpose cells in 2 column(s) starting with text2 1 into rows",
  341. "startColumnName": "text2 1",
  342. "columnCount": 2,
  343. "combinedColumnName": "",
  344. "prependColumnName": false,
  345. "separator": ":",
  346. "ignoreBlankCells": true
  347. },
  348. {
  349. "op": "core/column-addition",
  350. "description": "Create column hastag at index 4 based on column text2 1 using expression grel:value",
  351. "engineConfig": {
  352. "facets": [
  353. {
  354. "query": "#",
  355. "name": "text2 1",
  356. "caseSensitive": false,
  357. "columnName": "text2 1",
  358. "type": "text",
  359. "mode": "text"
  360. }
  361. ],
  362. "mode": "row-based"
  363. },
  364. "newColumnName": "hastag",
  365. "columnInsertIndex": 4,
  366. "baseColumnName": "text2 1",
  367. "expression": "grel:value",
  368. "onError": "set-to-blank"
  369. },
  370. {
  371. "op": "core/column-addition",
  372. "description": "Create column mention at index 4 based on column text2 1 using expression grel:value",
  373. "engineConfig": {
  374. "facets": [
  375. {
  376. "query": "@",
  377. "name": "text2 1",
  378. "caseSensitive": false,
  379. "columnName": "text2 1",
  380. "type": "text",
  381. "mode": "text"
  382. }
  383. ],
  384. "mode": "row-based"
  385. },
  386. "newColumnName": "mention",
  387. "columnInsertIndex": 4,
  388. "baseColumnName": "text2 1",
  389. "expression": "grel:value",
  390. "onError": "set-to-blank"
  391. },
  392. {
  393. "op": "core/column-removal",
  394. "description": "Remove column text2 1",
  395. "columnName": "text2 1"
  396. },
  397. {
  398. "op": "core/row-star",
  399. "description": "Star rows",
  400. "engineConfig": {
  401. "facets": [
  402. {
  403. "invert": false,
  404. "expression": "isBlank(value)",
  405. "selectError": false,
  406. "omitError": false,
  407. "selectBlank": false,
  408. "name": "hastag",
  409. "omitBlank": false,
  410. "columnName": "hastag",
  411. "type": "list",
  412. "selection": [
  413. {
  414. "v": {
  415. "v": false,
  416. "l": "false"
  417. }
  418. }
  419. ]
  420. }
  421. ],
  422. "mode": "row-based"
  423. },
  424. "starred": true
  425. },
  426. {
  427. "op": "core/row-star",
  428. "description": "Star rows",
  429. "engineConfig": {
  430. "facets": [
  431. {
  432. "invert": false,
  433. "expression": "isBlank(value)",
  434. "selectError": false,
  435. "omitError": false,
  436. "selectBlank": false,
  437. "name": "mention",
  438. "omitBlank": false,
  439. "columnName": "mention",
  440. "type": "list",
  441. "selection": [
  442. {
  443. "v": {
  444. "v": false,
  445. "l": "false"
  446. }
  447. }
  448. ]
  449. }
  450. ],
  451. "mode": "row-based"
  452. },
  453. "starred": true
  454. },
  455. {
  456. "op": "core/row-star",
  457. "description": "Star rows",
  458. "engineConfig": {
  459. "facets": [
  460. {
  461. "invert": false,
  462. "expression": "isBlank(value)",
  463. "selectError": false,
  464. "omitError": false,
  465. "selectBlank": false,
  466. "name": "from_user",
  467. "omitBlank": false,
  468. "columnName": "from_user",
  469. "type": "list",
  470. "selection": [
  471. {
  472. "v": {
  473. "v": false,
  474. "l": "false"
  475. }
  476. }
  477. ]
  478. }
  479. ],
  480. "mode": "row-based"
  481. },
  482. "starred": true
  483. },
  484. {
  485. "op": "core/row-removal",
  486. "description": "Remove rows",
  487. "engineConfig": {
  488. "facets": [
  489. {
  490. "invert": false,
  491. "expression": "row.starred",
  492. "selectError": false,
  493. "omitError": false,
  494. "selectBlank": false,
  495. "name": "Starred Rows",
  496. "omitBlank": false,
  497. "columnName": "",
  498. "type": "list",
  499. "selection": [
  500. {
  501. "v": {
  502. "v": false,
  503. "l": "false"
  504. }
  505. }
  506. ]
  507. }
  508. ],
  509. "mode": "row-based"
  510. }
  511. },
  512. {
  513. "op": "core/row-star",
  514. "description": "Unstar rows",
  515. "engineConfig": {
  516. "facets": [],
  517. "mode": "row-based"
  518. },
  519. "starred": false
  520. }
  521. ]