Stored transformation detail

def v($k): .[$k].value // null; def trim: gsub("^\\s+|\\s+$"; ""); def clean_text: tostring | gsub("\\s+"; " ") | trim; def province_from_postal_code($cp): if $cp | startswith("28") then "Madrid" else null end; def ac_from_postal_code($cp): if $cp | startswith("28") then "Comunidad de Madrid" else null end; def parsed_address: (v("address")) as $a | if ($a == null) or (($a | type) != "string") or (($a | clean_text) == "") then null else ($a | clean_text | gsub("\\.$"; "")) as $raw | if ($raw | test("\\b\\d{5}\\b")) then ($raw | capture("^(?<streetAddress>.*?)[,.;]?\\s*(?<postalCode>\\d{5})\\s+(?<municipality>[^,.;]+)")) as $m | {streetAddress: ($m.streetAddress | clean_text | gsub("[,.;]$"; "")), postalCode: $m.postalCode, municipality: ($m.municipality | clean_text), province: province_from_postal_code($m.postalCode), autonomousCommunity: ac_from_postal_code($m.postalCode), country: "España"} | with_entries(select(.value != null and .value != "")) else {streetAddress: $raw, country: "España"} end end; (parsed_address) as $loc | {object: ({name: {value: "Hotel PID", lang: "es"}} + (if v("description") != null then {hasDescription: {object: {shortDescription: {value: v("description"), lang: "es"}}}} else {} end) + (if $loc != null then {hasLocation: {object: $loc}} else {} end))}

{
  "object": {
    "hasDescription": {
      "object": {
        "shortDescription": {
          "lang": "es",
          "value": "Aparthotel TH Las Rozas"
        }
      }
    },
    "hasLocation": {
      "object": {
        "autonomousCommunity": "Comunidad de Madrid",
        "country": "Espa\u00f1a",
        "municipality": "Las Rozas",
        "postalCode": "28230",
        "province": "Madrid",
        "streetAddress": "Camino Viejo de Madrid, 38"
      }
    },
    "name": {
      "lang": "es",
      "value": "Hotel PID"
    }
  }
}