Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to remove certain strings from a field

Topic Labels: Formulas
Solved
Jump to Solution
4100 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Antony_Bearpark
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

You would need a nested SUBSTITUTE() formula:

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