My dirty data 2

co-address-cleaning.json

{
   "alwaysShowComment": false,
   "preview": false,
   "params": {
      "matching": "PATTERN",
      "stopAfterFirstMatch": false,
      "appliesTo": "COLUMNS",
      "normalization": "EXACT",
      "columns": [
         "DIR,C,60"
      ],
      "mapping": [
         {
            "to": "# $2$1 ",
            "from": "# ([a-z]) {0,1}(\\d+?) "
         },
         {
            "to": "$1 $2 $3 # $4 - $5 $6",
            "from": "^(avenida calle|avenida carrera|autopista|avenida|circular|calle|diagonal|carrera|transversal|bulevar|carretera|cuentas corridas|pasaje|paseo|peatonal|troncal|variante|via) ((?:\\d{1,4}(?: {0,1}?[a-z]{0,2}?| {0,1}[a-z][0-9][a-z])(?: {0,1}bis(?: {0,1}[a-z]{1,2}| {0,1}[a-z][0-9][a-z]|)|)|.*?\\b.*\\b))(?: {0,1}(norte|sur|oeste|este)|)(?: # | #| )(\\d{1,4}(?: {0,1}[a-z]{1,2}| {0,1}[a-z][0-9][a-z]|)(?: {0,1}bis(?: {0,1}?[a-z]{0,2}?| {0,1}[a-z][0-9][a-z])|))(?: - |- | -|-| )(\\d{1,4}(?: {0,1}(norte|sur|oeste|este)|)).*$"
         },
         {
            "to": " ",
            "from": "\\s{2,6}"
         },
         {
            "to": "$1 $2 $3 # $4 - $6 $5",
            "from": "^(avenida calle|avenida carrera|autopista|avenida|circular|calle|diagonal|carrera|transversal|bulevar|carretera|cuentas corridas|pasaje|paseo|peatonal|troncal|variante|via) ((?:\\d{1,4}(?: {0,1}?[a-z]{0,2}?| {0,1}[a-z][0-9][a-z])(?: {0,1}bis(?: {0,1}[a-z]{1,2}| {0,1}[a-z][0-9][a-z]|)|)|.*?\\b.*\\b))(?: {0,1}(norte|sur|oeste|este)|)(?: # | #| )(\\d{1,4}(?: {0,1}[a-z]{1,2}| {0,1}[a-z][0-9][a-z]|)(?: {0,1}bis(?: {0,1}?[a-z]{0,2}?| {0,1}[a-z][0-9][a-z])|)) (norte|sur|oeste|este)(?: - |- | -|-| )(\\d{1,4})"
         },
         {
            "to": " ",
            "from": "\\s{2,5}"
         }
      ],
      "output": ""
   },
   "type": "FindReplace",
   "disabled": false,
   "metaType": "PROCESSOR"
}