Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1.  
  2. [
  3. {
  4. "op": "core/text-transform",
  5. "description": "Text transform on cells in column Col1 2 using expression value.trim()",
  6. "engineConfig": {
  7. "facets": [],
  8. "mode": "row-based"
  9. },
  10. "columnName": "Col1 2",
  11. "expression": "value.trim()",
  12. "onError": "keep-original",
  13. "repeat": false,
  14. "repeatCount": 10
  15. },
  16. {
  17. "op": "core/text-transform",
  18. "description": "Text transform on cells in column Col1 2 using expression grel:value.partition(\" \", true).join(\"|\")",
  19. "engineConfig": {
  20. "facets": [],
  21. "mode": "row-based"
  22. },
  23. "columnName": "Col1 2",
  24. "expression": "grel:value.partition(\" \", true).join(\"|\")",
  25. "onError": "set-to-blank",
  26. "repeat": false,
  27. "repeatCount": 10
  28. },
  29. {
  30. "op": "core/column-split",
  31. "description": "Split column Col1 2 by separator",
  32. "engineConfig": {
  33. "facets": [],
  34. "mode": "row-based"
  35. },
  36. "columnName": "Col1 2",
  37. "guessCellType": true,
  38. "removeOriginalColumn": true,
  39. "mode": "separator",
  40. "separator": "|",
  41. "regex": false,
  42. "maxColumns": 2
  43. },
  44. {
  45. "op": "core/column-rename",
  46. "description": "Rename column Col1 2 1 to FirstName",
  47. "oldColumnName": "Col1 2 1",
  48. "newColumnName": "FirstName"
  49. }
  50. ]