Skip to content

Instantly share code, notes, and snippets.

@Sillson

Sillson/capitalize.js

Created September 19, 2018 23:13
Show Gist options
  • Save Sillson/d2f498e5629dc03df238d07ab7532dab to your computer and use it in GitHub Desktop.
Save Sillson/d2f498e5629dc03df238d07ab7532dab to your computer and use it in GitHub Desktop.
Download ZIP
capitalize function in bigquery
Raw
capitalize.js
CREATE TEMPORARY FUNCTION capitalize(str STRING)
RETURNS STRING
LANGUAGE js AS """
return str.replace(
/\\w\\S*/g,
function(txt) {
return txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase();
}
);
""";
@Sillson
Copy link
Author

Sillson commented Sep 19, 2018

#Importante
make sure you CASE when there could be null values

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment