Help

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

Solved
Jump to Solution
2608 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Momin_Bannani
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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.

Thank you Kuovonne, It worked :metal: