Bigquery

• syntax

  • Undumb My Data — RegEx Substring Pattern

Examples

• split between street name and house number  (*still a bit faulty)

REGEXP_REPLACE('Haupstraße92',r'(\w)(\d+)','\\1 \\2')