Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to remove certain strings from a field

Topic Labels: Formulas
Solved
Jump to Solution
1605 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a bunch of different strings of text and want to remove different phrases, but I’m unsure of the formula. Here is an example of what it may contain:

123.jpg
234.eps
345.ai
546%20(1).eps

I want to remove every instance of “.jpg”, “.eps”, “.ai” and “%20(1)”

Is there a way to do so?

1 Solution

Accepted Solutions

You would need a nested SUBSTITUTE() formula:

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Field Name}, '.jpg', ''), '.eps', ''), '.ai', ''), '%20(1)', '')

See Solution in Thread

1 Reply 1

You would need a nested SUBSTITUTE() formula:

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Field Name}, '.jpg', ''), '.eps', ''), '.ai', ''), '%20(1)', '')