davidm10's avatar
davidm10
New Member
9 years ago
Status:
Needs Votes

Strip non-numeric characters from a numeric column

Instead of having to know what values to filter and creating several replace value steps, an excellent data cleaning action would be to remove any non-numeric characters from a column you have set to be numeric. Vice versa could also apply. This would be a robust way to programmatically clean data when you don't know the dirtiness in the data that may come up in a future refresh

Recent ideas