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:

{
  "col1": 1,
  "col_2": 2,
  "col3": 3,
  "column4": 4,
  "col_5": 5
}