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.
Solved! Go to 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.🙂
Emmanuel_G - thanks so much for the response. Worked perfectly!
@vincent_gallo Good to know 🙂 !