The CLEANSE-COLUMN-NAMES directive sanitizes 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 (_)
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
}