The CLEANSE-COLUMN-NAMES directive sanatizes column names, following these rules:
- Trim 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 (_)
cleanse-column-names
Using this record as an example:
{
"COL1": 1,
"col:2": 2,
"Col3": 3,
"COLUMN4": 4,
"col!5": 5
}
Applying this directive:
cleanse-column-names
would result in this record:
{
"col1": 1,
"col_2": 2,
"col3": 3,
"column4": 4,
"col_5": 5
}