API tools faq
paste
Guest User

soup.io to WP using google refine

a guest
Aug 5th, 2011
247
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.50 KB | None | 0 0
raw download clone embed print report
  1. [
  2. {
  3. "op": "core/column-addition",
  4. "description": "Create column post_author at index 1 based on column Column using expression grel:value",
  5. "engineConfig": {
  6. "facets": [],
  7. "mode": "row-based"
  8. },
  9. "newColumnName": "post_author",
  10. "columnInsertIndex": 1,
  11. "baseColumnName": "Column",
  12. "expression": "grel:value",
  13. "onError": "set-to-blank"
  14. },
  15. {
  16. "op": "core/text-transform",
  17. "description": "Text transform on cells in column post_author using expression null",
  18. "engineConfig": {
  19. "facets": [],
  20. "mode": "row-based"
  21. },
  22. "columnName": "post_author",
  23. "expression": "null",
  24. "onError": "keep-original",
  25. "repeat": false,
  26. "repeatCount": 10
  27. },
  28. {
  29. "op": "core/column-addition",
  30. "description": "Create column post_date at index 2 based on column post_author using expression grel:value",
  31. "engineConfig": {
  32. "facets": [],
  33. "mode": "row-based"
  34. },
  35. "newColumnName": "post_date",
  36. "columnInsertIndex": 2,
  37. "baseColumnName": "post_author",
  38. "expression": "grel:value",
  39. "onError": "set-to-blank"
  40. },
  41. {
  42. "op": "core/column-addition",
  43. "description": "Create column post_date_gmt at index 3 based on column post_author using expression grel:value",
  44. "engineConfig": {
  45. "facets": [],
  46. "mode": "row-based"
  47. },
  48. "newColumnName": "post_date_gmt",
  49. "columnInsertIndex": 3,
  50. "baseColumnName": "post_author",
  51. "expression": "grel:value",
  52. "onError": "set-to-blank"
  53. },
  54. {
  55. "op": "core/column-addition",
  56. "description": "Create column post_content at index 4 based on column post_author using expression grel:value",
  57. "engineConfig": {
  58. "facets": [],
  59. "mode": "row-based"
  60. },
  61. "newColumnName": "post_content",
  62. "columnInsertIndex": 4,
  63. "baseColumnName": "post_author",
  64. "expression": "grel:value",
  65. "onError": "set-to-blank"
  66. },
  67. {
  68. "op": "core/column-addition",
  69. "description": "Create column post_title at index 5 based on column post_author using expression grel:value",
  70. "engineConfig": {
  71. "facets": [],
  72. "mode": "row-based"
  73. },
  74. "newColumnName": "post_title",
  75. "columnInsertIndex": 5,
  76. "baseColumnName": "post_author",
  77. "expression": "grel:value",
  78. "onError": "set-to-blank"
  79. },
  80. {
  81. "op": "core/column-addition",
  82. "description": "Create column post_excerpt at index 6 based on column post_author using expression grel:value",
  83. "engineConfig": {
  84. "facets": [],
  85. "mode": "row-based"
  86. },
  87. "newColumnName": "post_excerpt",
  88. "columnInsertIndex": 6,
  89. "baseColumnName": "post_author",
  90. "expression": "grel:value",
  91. "onError": "set-to-blank"
  92. },
  93. {
  94. "op": "core/column-addition",
  95. "description": "Create column post_status at index 7 based on column post_author using expression grel:value",
  96. "engineConfig": {
  97. "facets": [],
  98. "mode": "row-based"
  99. },
  100. "newColumnName": "post_status",
  101. "columnInsertIndex": 7,
  102. "baseColumnName": "post_author",
  103. "expression": "grel:value",
  104. "onError": "set-to-blank"
  105. },
  106. {
  107. "op": "core/column-addition",
  108. "description": "Create column comment_status at index 8 based on column post_author using expression grel:value",
  109. "engineConfig": {
  110. "facets": [],
  111. "mode": "row-based"
  112. },
  113. "newColumnName": "comment_status",
  114. "columnInsertIndex": 8,
  115. "baseColumnName": "post_author",
  116. "expression": "grel:value",
  117. "onError": "set-to-blank"
  118. },
  119. {
  120. "op": "core/column-addition",
  121. "description": "Create column ping_status at index 9 based on column post_author using expression grel:value",
  122. "engineConfig": {
  123. "facets": [],
  124. "mode": "row-based"
  125. },
  126. "newColumnName": "ping_status",
  127. "columnInsertIndex": 9,
  128. "baseColumnName": "post_author",
  129. "expression": "grel:value",
  130. "onError": "set-to-blank"
  131. },
  132. {
  133. "op": "core/column-addition",
  134. "description": "Create column post_password at index 10 based on column post_author using expression grel:value",
  135. "engineConfig": {
  136. "facets": [],
  137. "mode": "row-based"
  138. },
  139. "newColumnName": "post_password",
  140. "columnInsertIndex": 10,
  141. "baseColumnName": "post_author",
  142. "expression": "grel:value",
  143. "onError": "set-to-blank"
  144. },
  145. {
  146. "op": "core/column-addition",
  147. "description": "Create column post_name at index 11 based on column post_author using expression grel:value",
  148. "engineConfig": {
  149. "facets": [],
  150. "mode": "row-based"
  151. },
  152. "newColumnName": "post_name",
  153. "columnInsertIndex": 11,
  154. "baseColumnName": "post_author",
  155. "expression": "grel:value",
  156. "onError": "set-to-blank"
  157. },
  158. {
  159. "op": "core/column-addition",
  160. "description": "Create column to_ping at index 12 based on column post_author using expression grel:value",
  161. "engineConfig": {
  162. "facets": [],
  163. "mode": "row-based"
  164. },
  165. "newColumnName": "to_ping",
  166. "columnInsertIndex": 12,
  167. "baseColumnName": "post_author",
  168. "expression": "grel:value",
  169. "onError": "set-to-blank"
  170. },
  171. {
  172. "op": "core/column-addition",
  173. "description": "Create column pinged at index 13 based on column post_author using expression grel:value",
  174. "engineConfig": {
  175. "facets": [],
  176. "mode": "row-based"
  177. },
  178. "newColumnName": "pinged",
  179. "columnInsertIndex": 13,
  180. "baseColumnName": "post_author",
  181. "expression": "grel:value",
  182. "onError": "set-to-blank"
  183. },
  184. {
  185. "op": "core/column-addition",
  186. "description": "Create column post_modified at index 14 based on column post_author using expression grel:value",
  187. "engineConfig": {
  188. "facets": [],
  189. "mode": "row-based"
  190. },
  191. "newColumnName": "post_modified",
  192. "columnInsertIndex": 14,
  193. "baseColumnName": "post_author",
  194. "expression": "grel:value",
  195. "onError": "set-to-blank"
  196. },
  197. {
  198. "op": "core/column-addition",
  199. "description": "Create column post_modified_gmt at index 15 based on column post_author using expression grel:value",
  200. "engineConfig": {
  201. "facets": [],
  202. "mode": "row-based"
  203. },
  204. "newColumnName": "post_modified_gmt",
  205. "columnInsertIndex": 15,
  206. "baseColumnName": "post_author",
  207. "expression": "grel:value",
  208. "onError": "set-to-blank"
  209. },
  210. {
  211. "op": "core/column-addition",
  212. "description": "Create column post_content_filtered at index 16 based on column post_author using expression grel:value",
  213. "engineConfig": {
  214. "facets": [],
  215. "mode": "row-based"
  216. },
  217. "newColumnName": "post_content_filtered",
  218. "columnInsertIndex": 16,
  219. "baseColumnName": "post_author",
  220. "expression": "grel:value",
  221. "onError": "set-to-blank"
  222. },
  223. {
  224. "op": "core/column-addition",
  225. "description": "Create column post_parent at index 17 based on column post_author using expression grel:value",
  226. "engineConfig": {
  227. "facets": [],
  228. "mode": "row-based"
  229. },
  230. "newColumnName": "post_parent",
  231. "columnInsertIndex": 17,
  232. "baseColumnName": "post_author",
  233. "expression": "grel:value",
  234. "onError": "set-to-blank"
  235. },
  236. {
  237. "op": "core/column-addition",
  238. "description": "Create column guid at index 18 based on column post_author using expression grel:value",
  239. "engineConfig": {
  240. "facets": [],
  241. "mode": "row-based"
  242. },
  243. "newColumnName": "guid",
  244. "columnInsertIndex": 18,
  245. "baseColumnName": "post_author",
  246. "expression": "grel:value",
  247. "onError": "set-to-blank"
  248. },
  249. {
  250. "op": "core/column-addition",
  251. "description": "Create column menu_order at index 19 based on column post_author using expression grel:value",
  252. "engineConfig": {
  253. "facets": [],
  254. "mode": "row-based"
  255. },
  256. "newColumnName": "menu_order",
  257. "columnInsertIndex": 19,
  258. "baseColumnName": "post_author",
  259. "expression": "grel:value",
  260. "onError": "set-to-blank"
  261. },
  262. {
  263. "op": "core/column-addition",
  264. "description": "Create column post_type at index 20 based on column post_author using expression grel:value",
  265. "engineConfig": {
  266. "facets": [],
  267. "mode": "row-based"
  268. },
  269. "newColumnName": "post_type",
  270. "columnInsertIndex": 20,
  271. "baseColumnName": "post_author",
  272. "expression": "grel:value",
  273. "onError": "set-to-blank"
  274. },
  275. {
  276. "op": "core/column-addition",
  277. "description": "Create column post_mime_type at index 21 based on column post_author using expression grel:value",
  278. "engineConfig": {
  279. "facets": [],
  280. "mode": "row-based"
  281. },
  282. "newColumnName": "post_mime_type",
  283. "columnInsertIndex": 21,
  284. "baseColumnName": "post_author",
  285. "expression": "grel:value",
  286. "onError": "set-to-blank"
  287. },
  288. {
  289. "op": "core/column-addition",
  290. "description": "Create column comment_count at index 22 based on column post_author using expression grel:value",
  291. "engineConfig": {
  292. "facets": [],
  293. "mode": "row-based"
  294. },
  295. "newColumnName": "comment_count",
  296. "columnInsertIndex": 22,
  297. "baseColumnName": "post_author",
  298. "expression": "grel:value",
  299. "onError": "set-to-blank"
  300. },
  301. {
  302. "op": "core/text-transform",
  303. "description": "Text transform on cells in column post_title using expression grel:cells[\"Column\"].value",
  304. "engineConfig": {
  305. "facets": [
  306. {
  307. "query": "<title>",
  308. "name": "Column",
  309. "caseSensitive": false,
  310. "columnName": "Column",
  311. "type": "text",
  312. "mode": "text"
  313. }
  314. ],
  315. "mode": "row-based"
  316. },
  317. "columnName": "post_title",
  318. "expression": "grel:cells[\"Column\"].value",
  319. "onError": "set-to-blank",
  320. "repeat": false,
  321. "repeatCount": 10
  322. },
  323. {
  324. "op": "core/text-transform",
  325. "description": "Text transform on cells in column post_title using expression grel:replace(value,\"<item>\", \"\")",
  326. "engineConfig": {
  327. "facets": [
  328. {
  329. "query": "<title>",
  330. "name": "Column",
  331. "caseSensitive": false,
  332. "columnName": "Column",
  333. "type": "text",
  334. "mode": "text"
  335. }
  336. ],
  337. "mode": "row-based"
  338. },
  339. "columnName": "post_title",
  340. "expression": "grel:replace(value,\"<item>\", \"\")",
  341. "onError": "set-to-blank",
  342. "repeat": false,
  343. "repeatCount": 10
  344. },
  345. {
  346. "op": "core/text-transform",
  347. "description": "Text transform on cells in column post_title using expression grel:replace(value,\"<title>\", \"\")",
  348. "engineConfig": {
  349. "facets": [
  350. {
  351. "query": "<title>",
  352. "name": "Column",
  353. "caseSensitive": false,
  354. "columnName": "Column",
  355. "type": "text",
  356. "mode": "text"
  357. }
  358. ],
  359. "mode": "row-based"
  360. },
  361. "columnName": "post_title",
  362. "expression": "grel:replace(value,\"<title>\", \"\")",
  363. "onError": "set-to-blank",
  364. "repeat": false,
  365. "repeatCount": 10
  366. },
  367. {
  368. "op": "core/text-transform",
  369. "description": "Text transform on cells in column post_title using expression grel:replace(value,\"</title>\", \"\")",
  370. "engineConfig": {
  371. "facets": [
  372. {
  373. "query": "<title>",
  374. "name": "Column",
  375. "caseSensitive": false,
  376. "columnName": "Column",
  377. "type": "text",
  378. "mode": "text"
  379. }
  380. ],
  381. "mode": "row-based"
  382. },
  383. "columnName": "post_title",
  384. "expression": "grel:replace(value,\"</title>\", \"\")",
  385. "onError": "set-to-blank",
  386. "repeat": false,
  387. "repeatCount": 10
  388. },
  389. {
  390. "op": "core/text-transform",
  391. "description": "Text transform on cells in column post_content using expression grel:cells[\"Column\"].value",
  392. "engineConfig": {
  393. "facets": [
  394. {
  395. "query": "<description>",
  396. "name": "Column",
  397. "caseSensitive": false,
  398. "columnName": "Column",
  399. "type": "text",
  400. "mode": "text"
  401. }
  402. ],
  403. "mode": "row-based"
  404. },
  405. "columnName": "post_content",
  406. "expression": "grel:cells[\"Column\"].value",
  407. "onError": "set-to-blank",
  408. "repeat": false,
  409. "repeatCount": 10
  410. },
  411. {
  412. "op": "core/column-split",
  413. "description": "Split column post_content by separator",
  414. "engineConfig": {
  415. "facets": [
  416. {
  417. "expression": "isBlank(value)",
  418. "invert": false,
  419. "selectError": false,
  420. "omitError": false,
  421. "name": "post_content",
  422. "selectBlank": false,
  423. "columnName": "post_content",
  424. "omitBlank": false,
  425. "type": "list",
  426. "selection": [
  427. {
  428. "v": {
  429. "v": false,
  430. "l": "false"
  431. }
  432. }
  433. ]
  434. }
  435. ],
  436. "mode": "row-based"
  437. },
  438. "columnName": "post_content",
  439. "guessCellType": true,
  440. "removeOriginalColumn": true,
  441. "mode": "separator",
  442. "separator": "<pubDate>",
  443. "regex": false,
  444. "maxColumns": 2
  445. },
  446. {
  447. "op": "core/column-rename",
  448. "description": "Rename column post_content 1 to post_content",
  449. "oldColumnName": "post_content 1",
  450. "newColumnName": "post_content"
  451. },
  452. {
  453. "op": "core/column-split",
  454. "description": "Split column post_content 2 by separator",
  455. "engineConfig": {
  456. "facets": [
  457. {
  458. "expression": "isBlank(value)",
  459. "invert": false,
  460. "selectError": false,
  461. "omitError": false,
  462. "name": "post_content",
  463. "selectBlank": false,
  464. "columnName": "post_content",
  465. "omitBlank": false,
  466. "type": "list",
  467. "selection": [
  468. {
  469. "v": {
  470. "v": false,
  471. "l": "false"
  472. }
  473. }
  474. ]
  475. }
  476. ],
  477. "mode": "row-based"
  478. },
  479. "columnName": "post_content 2",
  480. "guessCellType": true,
  481. "removeOriginalColumn": true,
  482. "mode": "separator",
  483. "separator": "GMT</pubDate>",
  484. "regex": false,
  485. "maxColumns": 2
  486. },
  487. {
  488. "op": "core/text-transform",
  489. "description": "Text transform on cells in column post_date using expression grel:cells[\"post_content 2 1\"].value",
  490. "engineConfig": {
  491. "facets": [
  492. {
  493. "expression": "isBlank(value)",
  494. "invert": false,
  495. "selectError": false,
  496. "omitError": false,
  497. "name": "post_content",
  498. "selectBlank": false,
  499. "columnName": "post_content",
  500. "omitBlank": false,
  501. "type": "list",
  502. "selection": [
  503. {
  504. "v": {
  505. "v": false,
  506. "l": "false"
  507. }
  508. }
  509. ]
  510. }
  511. ],
  512. "mode": "row-based"
  513. },
  514. "columnName": "post_date",
  515. "expression": "grel:cells[\"post_content 2 1\"].value",
  516. "onError": "set-to-blank",
  517. "repeat": false,
  518. "repeatCount": 10
  519. },
  520. {
  521. "op": "core/column-removal",
  522. "description": "Remove column post_content 2 1",
  523. "columnName": "post_content 2 1"
  524. },
  525. {
  526. "op": "core/text-transform",
  527. "description": "Text transform on cells in column post_author using expression grel:1",
  528. "engineConfig": {
  529. "facets": [
  530. {
  531. "invert": false,
  532. "expression": "isBlank(value)",
  533. "selectError": false,
  534. "omitError": false,
  535. "selectBlank": false,
  536. "name": "post_title",
  537. "omitBlank": false,
  538. "columnName": "post_title",
  539. "type": "list",
  540. "selection": [
  541. {
  542. "v": {
  543. "v": false,
  544. "l": "false"
  545. }
  546. }
  547. ]
  548. }
  549. ],
  550. "mode": "row-based"
  551. },
  552. "columnName": "post_author",
  553. "expression": "grel:1",
  554. "onError": "set-to-blank",
  555. "repeat": false,
  556. "repeatCount": 10
  557. },
  558. {
  559. "op": "core/text-transform",
  560. "description": "Text transform on cells in column post_status using expression grel:\"publish\"",
  561. "engineConfig": {
  562. "facets": [
  563. {
  564. "invert": false,
  565. "expression": "isBlank(value)",
  566. "selectError": false,
  567. "omitError": false,
  568. "selectBlank": false,
  569. "name": "post_title",
  570. "omitBlank": false,
  571. "columnName": "post_title",
  572. "type": "list",
  573. "selection": [
  574. {
  575. "v": {
  576. "v": false,
  577. "l": "false"
  578. }
  579. }
  580. ]
  581. }
  582. ],
  583. "mode": "row-based"
  584. },
  585. "columnName": "post_status",
  586. "expression": "grel:\"publish\"",
  587. "onError": "set-to-blank",
  588. "repeat": false,
  589. "repeatCount": 10
  590. },
  591. {
  592. "op": "core/text-transform",
  593. "description": "Text transform on cells in column comment_status using expression grel:\"open\"",
  594. "engineConfig": {
  595. "facets": [
  596. {
  597. "invert": false,
  598. "expression": "isBlank(value)",
  599. "selectError": false,
  600. "omitError": false,
  601. "selectBlank": false,
  602. "name": "post_title",
  603. "omitBlank": false,
  604. "columnName": "post_title",
  605. "type": "list",
  606. "selection": [
  607. {
  608. "v": {
  609. "v": false,
  610. "l": "false"
  611. }
  612. }
  613. ]
  614. }
  615. ],
  616. "mode": "row-based"
  617. },
  618. "columnName": "comment_status",
  619. "expression": "grel:\"open\"",
  620. "onError": "set-to-blank",
  621. "repeat": false,
  622. "repeatCount": 10
  623. },
  624. {
  625. "op": "core/text-transform",
  626. "description": "Text transform on cells in column ping_status using expression grel:\"open\"",
  627. "engineConfig": {
  628. "facets": [
  629. {
  630. "invert": false,
  631. "expression": "isBlank(value)",
  632. "selectError": false,
  633. "omitError": false,
  634. "selectBlank": false,
  635. "name": "post_title",
  636. "omitBlank": false,
  637. "columnName": "post_title",
  638. "type": "list",
  639. "selection": [
  640. {
  641. "v": {
  642. "v": false,
  643. "l": "false"
  644. }
  645. }
  646. ]
  647. }
  648. ],
  649. "mode": "row-based"
  650. },
  651. "columnName": "ping_status",
  652. "expression": "grel:\"open\"",
  653. "onError": "set-to-blank",
  654. "repeat": false,
  655. "repeatCount": 10
  656. },
  657. {
  658. "op": "core/text-transform",
  659. "description": "Text transform on cells in column post_parent using expression grel:0",
  660. "engineConfig": {
  661. "facets": [
  662. {
  663. "invert": false,
  664. "expression": "isBlank(value)",
  665. "selectError": false,
  666. "omitError": false,
  667. "selectBlank": false,
  668. "name": "post_title",
  669. "omitBlank": false,
  670. "columnName": "post_title",
  671. "type": "list",
  672. "selection": [
  673. {
  674. "v": {
  675. "v": false,
  676. "l": "false"
  677. }
  678. }
  679. ]
  680. }
  681. ],
  682. "mode": "row-based"
  683. },
  684. "columnName": "post_parent",
  685. "expression": "grel:0",
  686. "onError": "set-to-blank",
  687. "repeat": false,
  688. "repeatCount": 10
  689. },
  690. {
  691. "op": "core/text-transform",
  692. "description": "Text transform on cells in column menu_order using expression grel:0",
  693. "engineConfig": {
  694. "facets": [
  695. {
  696. "invert": false,
  697. "expression": "isBlank(value)",
  698. "selectError": false,
  699. "omitError": false,
  700. "selectBlank": false,
  701. "name": "post_title",
  702. "omitBlank": false,
  703. "columnName": "post_title",
  704. "type": "list",
  705. "selection": [
  706. {
  707. "v": {
  708. "v": false,
  709. "l": "false"
  710. }
  711. }
  712. ]
  713. }
  714. ],
  715. "mode": "row-based"
  716. },
  717. "columnName": "menu_order",
  718. "expression": "grel:0",
  719. "onError": "set-to-blank",
  720. "repeat": false,
  721. "repeatCount": 10
  722. },
  723. {
  724. "op": "core/text-transform",
  725. "description": "Text transform on cells in column post_type using expression grel:\"post\"",
  726. "engineConfig": {
  727. "facets": [
  728. {
  729. "invert": false,
  730. "expression": "isBlank(value)",
  731. "selectError": false,
  732. "omitError": false,
  733. "selectBlank": false,
  734. "name": "post_title",
  735. "omitBlank": false,
  736. "columnName": "post_title",
  737. "type": "list",
  738. "selection": [
  739. {
  740. "v": {
  741. "v": false,
  742. "l": "false"
  743. }
  744. }
  745. ]
  746. }
  747. ],
  748. "mode": "row-based"
  749. },
  750. "columnName": "post_type",
  751. "expression": "grel:\"post\"",
  752. "onError": "set-to-blank",
  753. "repeat": false,
  754. "repeatCount": 10
  755. },
  756. {
  757. "op": "core/text-transform",
  758. "description": "Text transform on cells in column comment_count using expression grel:0",
  759. "engineConfig": {
  760. "facets": [
  761. {
  762. "invert": false,
  763. "expression": "isBlank(value)",
  764. "selectError": false,
  765. "omitError": false,
  766. "selectBlank": false,
  767. "name": "post_title",
  768. "omitBlank": false,
  769. "columnName": "post_title",
  770. "type": "list",
  771. "selection": [
  772. {
  773. "v": {
  774. "v": false,
  775. "l": "false"
  776. }
  777. }
  778. ]
  779. }
  780. ],
  781. "mode": "row-based"
  782. },
  783. "columnName": "comment_count",
  784. "expression": "grel:0",
  785. "onError": "set-to-blank",
  786. "repeat": false,
  787. "repeatCount": 10
  788. },
  789. {
  790. "op": "core/column-split",
  791. "description": "Split column post_content 2 2 by separator",
  792. "engineConfig": {
  793. "facets": [],
  794. "mode": "row-based"
  795. },
  796. "columnName": "post_content 2 2",
  797. "guessCellType": true,
  798. "removeOriginalColumn": true,
  799. "mode": "separator",
  800. "separator": "</guid>",
  801. "regex": false,
  802. "maxColumns": 2
  803. },
  804. {
  805. "op": "core/column-split",
  806. "description": "Split column post_content 2 2 2 by separator",
  807. "engineConfig": {
  808. "facets": [],
  809. "mode": "row-based"
  810. },
  811. "columnName": "post_content 2 2 2",
  812. "guessCellType": true,
  813. "removeOriginalColumn": true,
  814. "mode": "separator",
  815. "separator": "<category ",
  816. "regex": false,
  817. "maxColumns": 2
  818. },
  819. {
  820. "op": "core/column-rename",
  821. "description": "Rename column post_content 2 2 2 2 to tag & cat.",
  822. "oldColumnName": "post_content 2 2 2 2",
  823. "newColumnName": "tag & cat."
  824. },
  825. {
  826. "op": "core/column-move",
  827. "description": "Move column tag & cat. to position 0",
  828. "columnName": "tag & cat.",
  829. "index": 0
  830. },
  831. {
  832. "op": "core/text-transform",
  833. "description": "Text transform on cells in column guid using expression grel:cells[\"post_content 2 2 2 1\"].value",
  834. "engineConfig": {
  835. "facets": [],
  836. "mode": "row-based"
  837. },
  838. "columnName": "guid",
  839. "expression": "grel:cells[\"post_content 2 2 2 1\"].value",
  840. "onError": "keep-original",
  841. "repeat": false,
  842. "repeatCount": 10
  843. },
  844. {
  845. "op": "core/column-removal",
  846. "description": "Remove column post_content 2 2 2 1",
  847. "columnName": "post_content 2 2 2 1"
  848. },
  849. {
  850. "op": "core/text-transform",
  851. "description": "Text transform on cells in column post_date using expression value.toDate()",
  852. "engineConfig": {
  853. "facets": [],
  854. "mode": "row-based"
  855. },
  856. "columnName": "post_date",
  857. "expression": "value.toDate()",
  858. "onError": "keep-original",
  859. "repeat": false,
  860. "repeatCount": 10
  861. },
  862. {
  863. "op": "core/text-transform",
  864. "description": "Text transform on cells in column post_date_gmt using expression grel:cells[\"post_date\"].value",
  865. "engineConfig": {
  866. "facets": [],
  867. "mode": "row-based"
  868. },
  869. "columnName": "post_date_gmt",
  870. "expression": "grel:cells[\"post_date\"].value",
  871. "onError": "keep-original",
  872. "repeat": false,
  873. "repeatCount": 10
  874. },
  875. {
  876. "op": "core/text-transform",
  877. "description": "Text transform on cells in column post_modified using expression grel:cells[\"post_date\"].value",
  878. "engineConfig": {
  879. "facets": [],
  880. "mode": "row-based"
  881. },
  882. "columnName": "post_modified",
  883. "expression": "grel:cells[\"post_date\"].value",
  884. "onError": "keep-original",
  885. "repeat": false,
  886. "repeatCount": 10
  887. },
  888. {
  889. "op": "core/text-transform",
  890. "description": "Text transform on cells in column post_modified_gmt using expression grel:cells[\"post_date\"].value",
  891. "engineConfig": {
  892. "facets": [],
  893. "mode": "row-based"
  894. },
  895. "columnName": "post_modified_gmt",
  896. "expression": "grel:cells[\"post_date\"].value",
  897. "onError": "keep-original",
  898. "repeat": false,
  899. "repeatCount": 10
  900. },
  901. {
  902. "op": "core/text-transform",
  903. "description": "Text transform on cells in column post_name using expression grel:cells[\"post_title\"].value",
  904. "engineConfig": {
  905. "facets": [],
  906. "mode": "row-based"
  907. },
  908. "columnName": "post_name",
  909. "expression": "grel:cells[\"post_title\"].value",
  910. "onError": "set-to-blank",
  911. "repeat": false,
  912. "repeatCount": 10
  913. }
  914. ]
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!