regex101: PCRE (Legacy) Match Workspace

Pro

\ban ASCII word boundary

xthe literal x (120₁₀ / 170₈ / 78₁₆) (case sensitive)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

.*?any character (except for line terminators), repeated any number of times

_responsethe literal text _response (case sensitive)

.*?any character (except for line terminators), repeated any number of times

\ban ASCII word boundary

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

25 tokens

Regular Expression

\bx\..*?_response.*?\b,

New

x.A_response,
AAA_response_reason,
myTable.myColumn BBB_response_reason //space before BBB + no comma at the end of the word
myOtherColumn CCC_response_reason, //space before BBB + comma at the end of the word
myOtherColumn CCC_response_reason , //space before BBB + a space then a comma at the end of the word

Substitution

x.A_response,
AAA_response_reason,
myTable.myColumn BBB_response_reason //space before BBB + no comma at the end of the word
myOtherColumn CCC_response_reason, //space before BBB + comma at the end of the word
myOtherColumn CCC_response_reason , //space before BBB + a space then a comma at the end of the word