The new Clean Up Column Node provides options to clean data within selected columns - remove whitespace, letters, numbers, and more with a few clicks.
Use any of the Transform buttons to open the list of nodes and type Clean to highlight all the data cleaning nodes. Make sure to select the Clean Up Columns option.
Once connected to your data, select the column you would like to clean. You can group several columns in one row that will have the same cleanup options
Here's a list of the clean up options available and a short description for each:
You could choose one or many options from the list and the selection could be different for each column that you choose to clean.
This node pairs great with Clean Up and Remove Empty to prep your data.