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?
Yes as it's not in the exclusion list
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
Thank you. Would that also remove spaces? so '10 / 20' would be '1020'