Forum Discussion

peter's avatar
peter
New Contributor III
4 years ago

Remove unwanted characters from keys or column headings

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 li...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hey @peter,

Use the .replaceAll() function for all of the characters. It will look something like this:

$.mapKeys((value, key) => key.toLowerCase().replaceAll(' ','').replaceAll('(','').replaceAll(')',''))

There’s an option to list all characters in one function, like 'Replace all of these characters with ‘’ ’ but until I found the exact syntax, you can use a separate function for every character you want to remove.

Bojan