Remove data from field after date

[vincent_gallo]

Hoping someone will able to help me with an issue I'm having....

I have string field field that includes dates and other data.  I only need the data from the field up up to the end of the date in the string.  The dates are random so all I know is it will be in the format mm/dd.  Date appears at random locations within the string.

For example:

Field currently has "CDX.NA.IG.38 06/27 82.93" and I only need "CDX.NA.IG.38 06/27"

Thanks in advance.

[Emmanuel_G · Accepted solution]

Hi @vincent_gallo ,

Find attached the way to do this easily with regex formula.

As long as the dates keep the mm/dd format, it will work regardless of the date values ​​in question.

Let me know if it works as you want.🙂

[vincent_gallo]

Emmanuel_G - thanks so much for the response.  Worked perfectly!

[Emmanuel_G]

@vincent_gallo Good to know 🙂 !