Example for striping string, Python 3

Example for striping string

import json

res = """[
  {
    "CompanyName": "0-16",
    "Address": [
      "\r\n    ",
      "92 Water Lane",
      "\r\n    ",
      "\r\n    \r\n    \r\n    ",
      "\r\n    \t",
      "Wilmslow",
      "\r\n    \r\n    \t\r\n    ",
      "\r\n    \t",
      "Cheshire",
      "\r\n     \t\r\n    ",
      "SK9",
      " 5BB",
      "\r\n      \r\n    "
    ],
    "Tel": [
      " \r\n    \t\r\n    \t",
      "\r\n    \t\t01625",
      " 525164",
      "\r\n    \t\r\n    \t\t"
    ],
    "Fax": " 01625 525164",
    "email": "mailto:J.Petho@0-16.co.uk",
    "website": "http://www.0-16.co.uk "
  }
]"""

def clean_res(json_res):
    new_res = json.loads(json_res, strict=False)[0]
    
    print(new_res)
    
    address_arr = new_res['Address']
    clean_address = []

tel_arr = new_res['Tel']
    clean_tel = []

for element in address_arr:
        element = element.replace('\n', '')
        element = element.replace('\t', '')
        element = element.replace('\r', '')
        element = element.strip()

element is not '' and clean_address.append(element)

for element in tel_arr:
        element = element.replace('\n', '')
        element = element.replace('\t', '')
        element = element.replace('\r', '')
        element.strip()

element is not '' and clean_tel.append(element)

format_tel = ''.join(str(x) for x in clean_tel).strip()

new_res['Address'] = clean_address
    new_res['Tel'] = format_tel

return new_res

print(clean_res(res))


run \| edit \| history \| help	0

λ

                                      .NET NoSQL database for rapid development