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.

 

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support