Skip to main content

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?

You would need a nested SUBSTITUTE() formula:



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


Reply