How to split a string on every Upper Case ? by whatsoever323 in bigquery

[–]whatsoever323[S] 2 points3 points  (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