Sanitize text for formulas (all caps/lower case/strip punctuation, etc.)

Ideas & Features
1

I searched for this, but couldn’t find any details about basically sanitizing text so I can compare text in one field to another.

In my current case, I want to copy and paste language from a government database (the legal name of a company shown on the database) and compare that to the name of the company on my Fibery database. The government always all-caps names - but we would prefer to initial caps them.

Right now, if I have “COMPANY A” and “Company A” and a formula “Government name = Fibery name” - I get a false. I only get true if the second name is all caps.

But I can also imagine wanting to strip punctuation, like commas, etc. I’m aware of trim, but that’s pretty limited.

Thanks!

2

Use Lower() or Upper()

And you can use Replace() or ReplaceRegex() to remove superfluous punctuation.

3

Welp, I feel dumb. When I scrolled through I assumed Lower and Upper were basically Left and Right. ¯_(ツ)_/¯

Thank you. And yes, Replace is also a good idea. I appreciate it.

4

I’d use an extra field for both databases with the formula
trim(lower(name))
and

if needed and then compare those