import re
regex = re.compile(r",{0,1} \w+.(\w+), \w+.(\w+)", flags=re.MULTILINE)
test_str = (" v1.VAC_ID, v2.VAC_ID\n"
", v1.PAC_ID, v2.PAC_ID\n"
", v1.ICL_CPI, v2.ICL_CPI\n"
", v1.VAC_TVA, v2.VAC_TVA\n"
", v1.TVA_SID, v2.TVA_SID\n"
", v1.VAC_DAD, v2.VAC_DAD\n"
", v1.VAC_DAD_A, v2.VAC_DAD_A\n"
", v1.VAC_DAD_M, v2.VAC_DAD_M\n"
", v1.VAC_DAD_H, v2.VAC_DAD_H\n"
", v1.VAC_DOS, v2.VAC_DOS\n"
", v1.VAC_CPV, v2.VAC_CPV\n"
", v1.VAC_TAC, v2.VAC_TAC\n"
", v1.VAC_OIN, v2.VAC_OIN\n"
", v1.PRO_ID, v2.PRO_ID\n"
", v1.RCV_ID, v2.RCV_ID\n"
", v1.ID_HORA, v2.ID_HORA\n"
", v1.COUNT, v2.COUNT\n"
", v1.ASS_SEXE, v2.ASS_SEXE\n"
", v1.ASS_DNA, v2.ASS_DNA\n"
", v1.ASS_DNA_A, v2.ASS_DNA_A\n"
", v1.EDAT, v2.EDAT\n"
", v1.UPR_CUP, v2.UPR_CUP\n"
", v1.UPR_CUP_T, v2.UPR_CUP_T\n"
", v1.PAC_NIA, v2.PAC_NIA\n"
", v1.ASS_CSA, v2.ASS_CSA\n"
", v1.ICL_UP, v2.ICL_UP\n"
", v1.ICL_BAC, v2.ICL_BAC\n"
", v1.ICP_UP_ORIGINAL, v2.ICP_UP_ORIGINAL\n"
", v1.VAC_DED, v2.VAC_DED\n"
", v1.VAC_DED_TRUNC, v2.VAC_DED_TRUNC\n"
", v1.ICL_BAD, v2.ICL_BAD\n"
", v1.ICL_BAD_TRUNC, v2.ICL_BAD_TRUNC\n"
", v1.COUNT_ACTIUS, v2.COUNT_ACTIUS\n"
", v1.VAC_LOT, v2.VAC_LOT\n"
", v1.VAC_VIA, v2.VAC_VIA\n"
", v1.VAC_DCV, v2.VAC_DCV\n"
", v1.VAC_LAD, v2.VAC_LAD\n"
", v1.VAC_MNV, v2.VAC_MNV\n"
", v1.VAC_GPE, v2.VAC_GPE\n"
", v1.VAC_GPV, v2.VAC_GPV\n"
", v1.VAC_MCO, v2.VAC_MCO\n"
", v1.TSI_LOCALITAT, v2.TSI_LOCALITAT\n"
", v1.TSI_CPOSTAL, v2.TSI_CPOSTAL\n"
", v1.PAC_CIP, v2.PAC_CIP\n"
", v1.VAC_DAD_TRUNC, v2.VAC_DAD_TRUNC")
subst = "or decode(v1.$1, v2.$2, 1, 0) = 0"
result = regex.sub(subst, test_str)
if result:
print(result)
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Python, please visit: https://docs.python.org/3/library/re.html