import os if os.name =='nt': root = "//WDsentinel/share/CorpCDOs" elif os.name == 'posix': root = '/home/share/CorpCDOs' def sanitize_float(intex_float): try: intex_float = intex_float.replace(",", "") if " " in intex_float: #case of combo notes return float(intex_float.split(" ")[0]) if "(" in intex_float: return - float(intex_float[1:-1]) else: return float(intex_float) except (AttributeError, ValueError): return intex_float