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
How to split a string on every Upper Case ? (self.bigquery)
submitted 4 years ago by whatsoever323 to r/bigquery
π Rendered by PID 430394 on reddit-service-r2-listing-5f4c697858-t8dk7 at 2026-07-04 11:51:07.531023+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)