"TRIM" or "PROPER" in BigQuery
Is there a way to normalize rows in BigQuery?
My dataset looks like this:
Alpha Beta
Alpha BETA
alfa beta strong> // with a space after the 'beta'
Currently I can use bottom or top to normalize letters, but I don't know how to eliminate spaces before and after text. Does BigQuery have a function similar to "TRIM" in Excel?
+3
source to share
1 answer
BigQuery has LTRIM
(left justifies spaces) and RTRIM
(right justifies). (The string function documentation at https://cloud.google.com/bigquery/query-reference#stringfunctions missed them, we'll fix that shortly).
+5
source to share