Regular Expressions 101

Community Patterns

finding case statements in select

0

Regular Expression
Python

r"
=?case\s([\w\.='\"><\(\)\]\[,]+\s)?when\s[\s\w\.='\"><\(\)\]\[,]+?\sthen\s[\s\w\.='\"><\(\)\]\[,]+?\s(else\s[\s\w\.='\"><\(\)\]\[,]+?\s)?end(\sAS\s)?
"
gix

Description

no description available

Submitted by anonymous - 7 years ago