daily pastebin goal
58%
SHARE
TWEET

soup.io to WP using google refine

a guest Aug 5th, 2011 87 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. ]
RAW Paste Data
Top