Learning Google BigQuery

String Functions

The + operator can be used to concatenate string in legacy SQL but in standard SQL CONCAT function has to be used:

#standardSQLSELECT CONCAT('UNITED',' ','STATES')

The LENGTH function returns the length of the string passed as argument. The following query returns 5 as output:

SELECT LENGTH('INDIA')

The REPLACE function will replace the specified text with the replacement text. The following query will output *****@collegecronista.com this value:

SELECT REPLACE('[e-mail]','reachme','*****')

The SPLIT function splits the string by delimiter specified and returns an array of values. The output of the query is shown in the following screenshot:

#standardSQLSELECT SPLIT('1,2,3,4,5,6',',')