Skip to main content
Solved

How to remove certain strings from a field

  • September 30, 2020
  • 1 reply
  • 104 views
Antony_Bearpark
Forum|alt.badge.img+7

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?

Best answer by Kamille_Parks11

You would need a nested SUBSTITUTE() formula:

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

1 reply

Kamille_Parks11
Forum|alt.badge.img+27

You would need a nested SUBSTITUTE() formula:

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