How can I remove all special characters and spaces from values in a field?

NathanDorsch

I want to remove all special characters and spaces from a field in ETL.... how can I do this? Is there an easier way than having to create an individual replace text line for each specific character?

GrantSmith

Yes as it's not in the exclusion list

GrantSmith

Regular expressions are your friend in this case. You could ignore any non-alphanumeric characters in your string with something like this with a formula tile:

REGEXP_REPLACE(`field`, '[^a-zA-Z0-9]', '')

[] = Group of possible characters

^ = NOT

a-zA-Z any letter

0-9 = any digit

NathanDorsch

Thank you. Would that also remove spaces? so '10 / 20' would be '1020'

GrantSmith

Yes as it's not in the exclusion list

NathanDorsch

Thanks!