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

**URL:** https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510
**Category:** Ideas & Features
**Tags:** formulas
**Created:** [March 26, 2025, 3:33am UTC](https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510 "2025-03-26T03:33:59Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![CivicScribe88](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@CivicScribe88](https://community.fibery.io/u/CivicScribe88)
#### Post date: [March 26, 2025, 3:33am UTC](https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510/1 "2025-03-26T03:33:59Z")

</div>

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!

---

<div class="post-metadata">

### Author: ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [March 26, 2025, 6:37am UTC](https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510/2 "2025-03-26T06:37:18Z")

</div>

Use Lower() or Upper()

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

> **[Formulas Reference](https://the.fibery.io/@public/User_Guide/Guide/Formulas-Reference-44)**

---

<div class="post-metadata">

### Author: ![CivicScribe88](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@CivicScribe88](https://community.fibery.io/u/CivicScribe88)
#### Post date: [March 27, 2025, 4:15am UTC](https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510/3 "2025-03-27T04:15:03Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Eren\_Turgut](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/eren_turgut/32/4425_2.png) [@Eren\_Turgut](https://community.fibery.io/u/Eren_Turgut)
#### Post date: [March 28, 2025, 10:22am UTC](https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510/4 "2025-03-28T10:22:13Z")

</div>

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

> [@Chr1sG](#):
>
> And you can use Replace() or ReplaceRegex() to remove superfluous punctuation.

if needed and then compare those