format quote in case_data_index.json

case_data_index.py

import json
import re
from functools import reduce

PATTERNS = [
    '^(.*"BRIEF_CASE":")(.*)(","CASE_TYPE":.*)$',
    '^(.*"CASE_ADDRESS":")(.*)("},"ADDR_TYPE":.*)$',
    '^(.*"case_?[Aa]ddress":")(.*)(","table_?[Ss]ource":.*)$',
    '^(.*"caseAddress":")(.*)(","locationJson":.*)$',
    '^(.*"CASE_NAME":")(.*)(","CASE_NUMBER":.*)$',
    '^(.*"case_address":")(.*)(","location":.*)$',
]
COMPILED_PATTERNS = list(map(re.compile, PATTERNS))

def format_quote(s, r):
    search_result = r.search(s)
    if search_result is not None:
        matched = search_result.group(2).replace('"', '\\"')
        s = ''.join([search_result.group(1), matched, search_result.group(3)])
    return s

with open('./case_data_index.json', mode='r', encoding='utf-8') as f:
    for i, row in enumerate(f):
        print(i+1)
        row = reduce(format_quote, COMPILED_PATTERNS, row)
        json.loads(row)