Trim Middle of Field

[evansabres]

i have a field, NAME, that appears as 'Content-04042020-Content'

I would like to remove '-04042020' (so remove the first hyphen and keep the second). 

How can I do this in the expression?

[tresesco · Accepted solution]

Try like:

= Replace( NAME, TextBetween(NAME, '-','-')&'-', '')