Cleanse Column Names directive

Owned by Robin Rielley
Last updated: Aug 17, 2020
1 min read

The CLEANSE-COLUMN-NAMES directive sanitizes column names, following these rules:

  • Trims leading and trailing spaces

  • Lowercases the column name

  • Replaces any character that are not one of [A-Z][a-z][0-9] or _ with an underscore (_)

Syntax

cleanse-column-names

Example

Using this record as an example:

{ "COL1": 1, "col:2": 2, "Col3": 3, "COLUMN4": 4, "col!5": 5 }

Applying this directive:

cleanse-column-names

results in this record:

 

Created in 2020 by Google Inc.