fork download
copy 
  1. import re
  2.  
  3. pattern = r'\bcast\((")?(zone)(?(1)"|\s)'
  4. strings = [
  5.     'cast("zone" as varchar(100)) as zoneID',
  6.     'cast(zone as varchar(100)) as zoneID',
  7.     'cast(zone) as varchar(100)) as zoneID'
  8. ]
  9. for s in strings:
  10.     m = re.search(pattern, s)
  11.     if m:
  12.         print(f"{m.group(2)} ---> {s}")
Success #stdin #stdout 0.03s 9840KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
zone ---> cast("zone" as varchar(100)) as zoneID
zone ---> cast(zone as varchar(100)) as zoneID
https://ideone.com/NNbF7W
language:
Python 3 (python  3.12)
created:
2 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!