[
  {
    "op": "core/row-reorder",
    "mode": "row-based",
    "sorting": {
      "criteria": [
        {
          "valueType": "number",
          "column": "Num",
          "blankPosition": 2,
          "errorPosition": 1,
          "reverse": false
        }
      ]
    },
    "description": "Reorder rows"
  },
  {
    "op": "core/blank-down",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Num",
    "description": "Blank down cells in column Num"
  },
  {
    "op": "core/row-removal",
    "engineConfig": {
      "facets": [
        {
          "type": "list",
          "name": "Num",
          "expression": "isBlank(value)",
          "columnName": "Num",
          "invert": false,
          "omitBlank": false,
          "omitError": false,
          "selection": [
            {
              "v": {
                "v": true,
                "l": "true"
              }
            }
          ],
          "selectBlank": false,
          "selectError": false
        }
      ],
      "mode": "row-based"
    },
    "description": "Remove rows"
  },
  {
    "op": "core/fill-down",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "continent",
    "description": "Fill down cells in column continent"
  },
  {
    "op": "core/mass-edit",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "region",
    "expression": "value",
    "edits": [
      {
        "from": [
          "caribbean"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Caribbean"
      }
    ],
    "description": "Mass edit cells in column region"
  },
  {
    "op": "core/mass-edit",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "region",
    "expression": "value",
    "edits": [
      {
        "from": [
          "Central America "
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Central America"
      }
    ],
    "description": "Mass edit cells in column region"
  },
  {
    "op": "core/mass-edit",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "region",
    "expression": "value",
    "edits": [
      {
        "from": [
          "Central America  "
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Central America"
      }
    ],
    "description": "Mass edit cells in column region"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [
        {
          "type": "text",
          "name": "region",
          "columnName": "region",
          "query": "Central America",
          "mode": "text",
          "caseSensitive": false,
          "invert": false
        }
      ],
      "mode": "row-based"
    },
    "columnName": "country",
    "expression": "grel:value\n.replace('Guatemale','Guatemala')\n.replace('Hondures','Honduras')\n.replace('Nicarague','Nicaragua')\n.replace('El Salvadore','El Salvador')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Text transform on cells in column country using expression grel:value\n.replace('Guatemale','Guatemala')\n.replace('Hondures','Honduras')\n.replace('Nicarague','Nicaragua')\n.replace('El Salvadore','El Salvador')"
  },
  {
    "op": "core/column-addition",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "baseColumnName": "ganancias",
    "expression": "grel:value.match(/.*?(\\d+).*?/)[0]",
    "onError": "set-to-blank",
    "newColumnName": "ganancias_num",
    "columnInsertIndex": 19,
    "description": "Create column ganancias_num at index 19 based on column ganancias using expression grel:value.match(/.*?(\\d+).*?/)[0]"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "ganancias_num",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Text transform on cells in column ganancias_num using expression value.toNumber()"
  },
  {
    "op": "core/column-removal",
    "columnName": "ganancias_num",
    "description": "Remove column ganancias_num"
  },
  {
    "op": "core/mass-edit",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Street",
    "expression": "value",
    "edits": [
      {
        "from": [
          "HIGH STREET KINGS HEATH",
          "High Street Kings Heath",
          "Kings Heath High Street",
          "high street, kings heath"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Kings Heath High Street"
      },
      {
        "from": [
          "Stratford Road",
          "Stratford road",
          "stratford road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Stratford Road"
      },
      {
        "from": [
          "Stoney Lane",
          "stoney lane"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Stoney Lane"
      },
      {
        "from": [
          "Washwood Heath Road",
          "Washwood Heath road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Washwood Heath Road"
      },
      {
        "from": [
          "poplar road , solihull",
          "poplar road, solihull"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "poplar road , solihull"
      },
      {
        "from": [
          "Bordesley Green",
          "Bordesley Green , Bordesley Green."
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Bordesley Green"
      },
      {
        "from": [
          "Lea Hall RD",
          "Lea Hall rd"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Lea Hall RD"
      },
      {
        "from": [
          "Poplar road",
          "poplar road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Poplar road"
      },
      {
        "from": [
          "Heartlands Hospital A & E.",
          "heartlands hospital A & E."
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Heartlands Hospital A & E."
      },
      {
        "from": [
          "Alcester Road Moseley",
          "alcester road moseley"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Alcester Road Moseley"
      },
      {
        "from": [
          "Home Address",
          "home address"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Home Address"
      },
      {
        "from": [
          "gospel lane",
          "Gospel Lane"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "gospel lane"
      },
      {
        "from": [
          "SHirley Road",
          "Shirley Road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "SHirley Road"
      }
    ],
    "description": "Mass edit cells in column Street"
  },
  {
    "op": "core/mass-edit",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Street",
    "expression": "value",
    "edits": [
      {
        "from": [
          "BIRMINGHAM RD",
          "Birmingham Road",
          "Birmingham Road, Sutton Coldfield",
          "Birmingham Rd, SC",
          "Birmingham Road, Erdington",
          "birmingham road sutton"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "BIRMINGHAM RD"
      },
      {
        "from": [
          "COVENTRY RD, SMALL HEATH, BHAM",
          "Coventry Road, Small Heath",
          "Coventry rd Small heath",
          "coventry road,small heath"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Coventry Road, Small Heath"
      },
      {
        "from": [
          "Stratford Road",
          "stratford road, hall green",
          "stratford roads"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Stratford Road"
      },
      {
        "from": [
          "Alcester Road Moseley",
          "Alcester Raod, Mosley",
          "alcester road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Alcester Road Moseley"
      },
      {
        "from": [
          "Heartlands Hospital A & E.",
          "Heartlands Hospital"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Heartlands Hospital A & E."
      },
      {
        "from": [
          "Warwick Road",
          "wawrick road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Warwick Road"
      },
      {
        "from": [
          "Bromford Lane",
          "Bromford Lane, Erdington, B'ham"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Bromford Lane"
      },
      {
        "from": [
          "Hurst Street",
          "Hurst Street, Birmingham"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Hurst Street"
      },
      {
        "from": [
          "Cranes Park Road",
          "Cranes Park Road Sheldon"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Cranes Park Road"
      },
      {
        "from": [
          "Corporation St,Birmingham",
          "corporation street"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Corporation St,Birmingham"
      }
    ],
    "description": "Mass edit cells in column Street"
  },
  {
    "op": "core/mass-edit",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Street",
    "expression": "value",
    "edits": [
      {
        "from": [
          "Washwood Heath Road",
          "WASHWOOD HEATH RD, WASHWOOD HEATH, BHAM",
          "Washwood Heath pub"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Washwood Heath Road"
      },
      {
        "from": [
          "BIRMINGHAM RD",
          "Birmingham International railway station",
          "birmingham airport"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "BIRMINGHAM RD"
      },
      {
        "from": [
          "White Hart Public House",
          "Whiteheart pub, Gressell Lane"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "White Hart Public House"
      },
      {
        "from": [
          "Stechford P.S.",
          "Stechford front office"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Stechford P.S."
      },
      {
        "from": [
          "Police Station Stechford",
          "Police station"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Police Station Stechford"
      },
      {
        "from": [
          "Warwick Road",
          "Warwick Road Tysley"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Warwick Road"
      },
      {
        "from": [
          "Westley Road",
          "Westley Road, Acocks Green"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Westley Road"
      },
      {
        "from": [
          "William Hill Bookmakers, Washwood Heath Road",
          "William Hill Washwood Heath Road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "William Hill Bookmakers, Washwood Heath Road"
      },
      {
        "from": [
          "Church Road, Sheldon",
          "church rd, stechford"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Church Road, Sheldon"
      },
      {
        "from": [
          "Coventry Road",
          "Coventry Road, Small Heath"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Coventry Road"
      },
      {
        "from": [
          "Broad Street",
          "Broad Street Birmingham"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Broad Street"
      },
      {
        "from": [
          "Stratford Road",
          "STRATFORD HEATH, SPARK HILL, BIRMINGHAM"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Stratford Road"
      },
      {
        "from": [
          "Clock Lane",
          "Solihull Lane"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Clock Lane"
      },
      {
        "from": [
          "Belchers Lane",
          "Belchers Lane, Bordesley Green"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Belchers Lane"
      },
      {
        "from": [
          "Long Street. Sparkhill",
          "Long street"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Long Street. Sparkhill"
      },
      {
        "from": [
          "Moseley Village",
          "Moseley Village, Alcester road"
        ],
        "fromBlank": false,
        "fromError": false,
        "to": "Moseley Village"
      }
    ],
    "description": "Mass edit cells in column Street"
  },
  {
    "op": "core/column-addition",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "baseColumnName": "ganancias",
    "expression": "grel:value.match(/.*?(\\d+).*?/)[0]",
    "onError": "set-to-blank",
    "newColumnName": "ganancias_num",
    "columnInsertIndex": 19,
    "description": "Create column ganancias_num at index 19 based on column ganancias using expression grel:value.match(/.*?(\\d+).*?/)[0]"
  },
  {
    "op": "core/column-addition",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "baseColumnName": "dominio",
    "expression": "grel:value.substring(value.length()-3)",
    "onError": "set-to-blank",
    "newColumnName": "dominio_prefijo",
    "columnInsertIndex": 21,
    "description": "Create column dominio_prefijo at index 21 based on column dominio using expression grel:value.substring(value.length()-3)"
  }
]