Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
r"
^([^=\s]+)=
"
gm
Input 1
1
New
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
Substitution
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