I have a pipeline which reads zip files which contain csv files and loads the files into sql table.
The zip files contain csv files with column headings which contain spaces, ()/ etc and I would like to remove these fromt he column headings dynamically.
Column head 1 => ColumnHead1
Column/head (2) =>. ColumnHead2
I have used $.mapKeys((value, key) => key.toLowerCase().split(’ ‘).map(x=> x.capitalize()).join(’’)), Which removes spaces and Capitalises OK, but I cant figure out how to remove the other characters.