topic How to cut a specific string in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-cut-a-specific-string/m-p/668766#M36402 <P>Hello,</P><P>I'd like to cut off a specific part from string. I'm looking for solution made in query builder with enterprise guide. I want to delete all parts containing 'PL003' or 'PL005'.</P><P>Example string:</P><P>PL0031234</P><P>PL00512345</P><P>PL003PL005123456</P><P>&nbsp;</P><P>My target to achieve:</P><P>1234</P><P>12345</P><P>123456</P><P>Can you help me?</P> Mon, 13 Jul 2020 09:39:12 GMT PatrykSAS 2020-07-13T09:39:12Z How to cut a specific string https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-cut-a-specific-string/m-p/668766#M36402 <P>Hello,</P><P>I'd like to cut off a specific part from string. I'm looking for solution made in query builder with enterprise guide. I want to delete all parts containing 'PL003' or 'PL005'.</P><P>Example string:</P><P>PL0031234</P><P>PL00512345</P><P>PL003PL005123456</P><P>&nbsp;</P><P>My target to achieve:</P><P>1234</P><P>12345</P><P>123456</P><P>Can you help me?</P> Mon, 13 Jul 2020 09:39:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-cut-a-specific-string/m-p/668766#M36402 PatrykSAS 2020-07-13T09:39:12Z Re: How to cut a specific string https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-cut-a-specific-string/m-p/668778#M36404 <P>In the Query builder, create new calculated column, as 'Advanced Expression', and in the expression use the following</P> <PRE><CODE class=" language-sas">/* new */ (PRXCHANGE('s/PL00\d//',-1,t1.x)) AS new</CODE></PRE> <P>This will give you the desired output.</P> <P>&nbsp;</P> <P>Hope this helps,</P> <P>Ahmed</P> <P>&nbsp;</P> Mon, 13 Jul 2020 11:20:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-cut-a-specific-string/m-p/668778#M36404 AhmedAl_Attar 2020-07-13T11:20:55Z Re: How to cut a specific string https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-cut-a-specific-string/m-p/668781#M36405 <P>Thanks a lot! This expression works great.</P> Mon, 13 Jul 2020 11:28:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-cut-a-specific-string/m-p/668781#M36405 PatrykSAS 2020-07-13T11:28:19Z