How to automatically Removing Special Characters ~ ` ! @ # $ % & * ; : ? . , ’ "

I would like to remove the following special characters on the “project name”
~ ` ! @ # $ % & * ; : ? . , ’ "

UPPER(CONCATENATE(Language, “-”, Team, “-”, SUBSTITUTE({Project Name}, " ", “”), “-”, {Date Added to Airtable}))

Can someone help me :pray:

Thanks

It looks like you have a great start with using the SUBSTITUTE function to remove spaces. To remove additional characters, use nested substitution functions, as demonstrated in this post on creating slugs for webpages. That post replaces the special character with their url encoded equivalents, but you can remove them entirely if you like.

1 Like

Thank you Kuovonne, It worked :metal:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.