Replacing several words in a field

Options
Hi,
I am trying to create an app that replaces bad words with the right word. Say "Sh*t" with "Poop" 😀
So as the example, control the swearing.

I know I can make it using a Query all records and then using an IF to replace each word, but I have 10 words to check and end up having a lot of Else Ifs.

Wondering if there is a better and more optimized way to compare the field to this list of 10 words and do a quick replace without having too many IFS ELSE. Thank you very much in advance.

Comments