Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 14, 2023 11:22 AM
I am trying to incorporate a formula column which looks for entries which may include swear words, but I cant seem to get this formula to work. Here is a snippet (I've taken out a lot of the middle which is just 3230 different swear words) but the beginning and end are there. Any ideas?
Solved! Go to Solution.
Oct 15, 2023 04:15 AM - edited Oct 15, 2023 04:16 AM
I don't know if it could actually handle that number of words, but this regex formula seems better.
IF(REGEX_MATCH({Lower}&"", "2 girls 1 cup|2g1c|4r5e"),"!")
Oct 15, 2023 04:15 AM - edited Oct 15, 2023 04:16 AM
I don't know if it could actually handle that number of words, but this regex formula seems better.
IF(REGEX_MATCH({Lower}&"", "2 girls 1 cup|2g1c|4r5e"),"!")