Remove Non Alphanumeric Characters

Description

Removes all characters that are not numbers (0-9) or letters of the alphabet (A-Z/a-z) from a column value.

INPUT/Output DATA TYPE

Input	Output
text	text

 

example

In this example, Description is the original column, and Description Clean is the new column after Remove Non Alphanumeric Characters is applied:

 

Characters like the following: , $ & . are no longer present in the new column. Take into account that even punctuation marks are removed.