text = r"""SELECT
Involved_Party_ID=pt.ProgramId,
Involved_Party_Type=2,
First_Name=REPLACE(REPLACE(REPLACE(pt.ProgramName, '|', '/'), CHAR(10), ' '), CHAR(13), ' '),
Registration_Status=pt.RegistrationStatus,
Involved_Party_Status=CONVERT(SMALLINT, pt.ProgramStatus),
Creation_Date=pt.CreationDate,
Incorporation_Country=CONVERT(VARCHAR(50), CASE WHEN pd.IncorporationCountry='UK' THEN 'GB' ELSE pd.IncorporationCountry END),
FROM
SomeTable AS pt
GO"""
for line in iter(text.splitlines(False)):
if line.strip().startswith("SELECT"):
continue
elif line.strip().startswith("FROM"):
break
else:
result = line.strip().split("=", 1)[0]
print(result)
dGV4dCA9IHIiIiJTRUxFQ1QKSW52b2x2ZWRfUGFydHlfSUQ9cHQuUHJvZ3JhbUlkLApJbnZvbHZlZF9QYXJ0eV9UeXBlPTIsIApGaXJzdF9OYW1lPVJFUExBQ0UoUkVQTEFDRShSRVBMQUNFKHB0LlByb2dyYW1OYW1lLCAnfCcsICcvJyksIENIQVIoMTApLCAnICcpLCBDSEFSKDEzKSwgJyAnKSwKUmVnaXN0cmF0aW9uX1N0YXR1cz1wdC5SZWdpc3RyYXRpb25TdGF0dXMsCkludm9sdmVkX1BhcnR5X1N0YXR1cz1DT05WRVJUKFNNQUxMSU5ULCBwdC5Qcm9ncmFtU3RhdHVzKSwgCkNyZWF0aW9uX0RhdGU9cHQuQ3JlYXRpb25EYXRlLApJbmNvcnBvcmF0aW9uX0NvdW50cnk9Q09OVkVSVChWQVJDSEFSKDUwKSwgQ0FTRSBXSEVOIHBkLkluY29ycG9yYXRpb25Db3VudHJ5PSdVSycgVEhFTiAnR0InIEVMU0UgcGQuSW5jb3Jwb3JhdGlvbkNvdW50cnkgRU5EKSwKRlJPTQogICAgU29tZVRhYmxlIEFTIHB0CkdPIiIiCmZvciBsaW5lIGluIGl0ZXIodGV4dC5zcGxpdGxpbmVzKEZhbHNlKSk6CglpZiBsaW5lLnN0cmlwKCkuc3RhcnRzd2l0aCgiU0VMRUNUIik6CgkJY29udGludWUKCWVsaWYgbGluZS5zdHJpcCgpLnN0YXJ0c3dpdGgoIkZST00iKToKCQlicmVhawoJZWxzZToKCQlyZXN1bHQgPSBsaW5lLnN0cmlwKCkuc3BsaXQoIj0iLCAxKVswXQoJCXByaW50KHJlc3VsdCk=