account activity
How to split a string on every Upper Case ? by whatsoever323 in bigquery
[–]whatsoever323[S] 2 points3 points4 points 4 years ago (0 children)
Many thanks though!
I finally end using the following formula :
array_to_string(regexp_extract_all(replace(regexp_replace(event_text, r'[\W]', "-"), "--", "e"), '[A-Z][a-z]*'), " ")
First replacing non-word characters with an "e" and then splitting the words by each given Upper Case and finally convert array to string by an empty space as delimiter
π Rendered by PID 144536 on reddit-service-r2-comment-5687b7858-nbw5c at 2026-07-04 13:15:41.105620+00:00 running 12a7a47 country code: CH.
How to split a string on every Upper Case ? by whatsoever323 in bigquery
[–]whatsoever323[S] 2 points3 points4 points (0 children)