https://community.qlik.com/t5/App-Development/Trim-Middle-of-Field/m-p/1699122#M53527 <P>i have a field, NAME, that appears as 'Content-04042020-Content'</P><P>I would like to remove '-04042020' (so remove the first hyphen and keep the second).&nbsp;</P><P>How can I do this in the expression?</P> Tue, 05 May 2020 14:24:42 GMT evansabres 2020-05-05T14:24:42Z https://community.qlik.com/t5/App-Development/Trim-Middle-of-Field/m-p/1699122#M53527 <P>i have a field, NAME, that appears as 'Content-04042020-Content'</P><P>I would like to remove '-04042020' (so remove the first hyphen and keep the second).&nbsp;</P><P>How can I do this in the expression?</P> Tue, 05 May 2020 14:24:42 GMT https://community.qlik.com/t5/App-Development/Trim-Middle-of-Field/m-p/1699122#M53527 evansabres 2020-05-05T14:24:42Z https://community.qlik.com/t5/App-Development/Trim-Middle-of-Field/m-p/1699128#M53528 <P>Try like:</P><P>&nbsp;</P><P>= Replace( NAME, TextBetween(NAME, '-','-')&amp;'-', '')</P> Tue, 05 May 2020 14:49:10 GMT https://community.qlik.com/t5/App-Development/Trim-Middle-of-Field/m-p/1699128#M53528 tresB 2020-05-05T14:49:10Z