topic Re: replace a text &quot;&quot;,&quot;&quot; with &quot;,&quot; in sas in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/replace-a-text-quot-quot-quot-quot-with-quot-quot-in-sas/m-p/517352#M32613 <P>Use the TRANSTRN function</P> <P>&nbsp;</P> <P><A href="https://documentation.sas.com/?docsetId=lefunctionsref&amp;docsetTarget=n101a8jch5trh0n1bc5neq48hc89.htm&amp;docsetVersion=9.4&amp;locale=en" target="_self">https://documentation.sas.com/?docsetId=lefunctionsref&amp;docsetTarget=n101a8jch5trh0n1bc5neq48hc89.htm&amp;docsetVersion=9.4&amp;locale=en</A></P> <P>&nbsp;</P> <P>Use single quotes to enclose target and replacement strings containing double quotes : '"",""'</P> Fri, 30 Nov 2018 04:26:44 GMT PGStats 2018-11-30T04:26:44Z replace a text "","" with "," in sas https://communities.sas.com/t5/SAS-Enterprise-Guide/replace-a-text-quot-quot-quot-quot-with-quot-quot-in-sas/m-p/517343#M32612 <P>Hello all,&nbsp;</P><P>&nbsp;</P><P>am looking for a solution with a text in the column of a table&nbsp;</P><P>&nbsp;</P><P>Question 1 :&nbsp;</P><P>&nbsp;</P><P><STRONG>Input</STRONG> :&nbsp;"vg_PCI_Car<STRONG>"", ""</STRONG>vg_PCI_CivilLiability"<STRONG>", ""</STRONG>vg_PCI_Fire"</P><P><SPAN><STRONG>output:</STRONG> &nbsp;</SPAN><SPAN>"vg_PCI_Car</SPAN><STRONG>", "</STRONG><SPAN>vg_PCI_CivilLiability<STRONG>"</STRONG></SPAN><STRONG>, "</STRONG><SPAN>vg_PCI_Fire"</SPAN></P><P>&nbsp;</P><P>Question 2 :&nbsp;</P><P>&nbsp;</P><P><STRONG>Input</STRONG> : <SPAN>vg_PCI_Car</SPAN><STRONG>", "</STRONG><SPAN>vg_PCI_CivilLiability<STRONG>"</STRONG></SPAN><STRONG>, "</STRONG><SPAN>vg_PCI_Fire</SPAN></P><P><SPAN><STRONG>output:</STRONG> &nbsp;</SPAN><SPAN>vg_PCI_Car</SPAN><STRONG>_</STRONG><SPAN>vg_PCI_CivilLiability<STRONG>_</STRONG></SPAN><SPAN>vg_PCI_Fire"</SPAN></P><P>&nbsp;</P> Fri, 30 Nov 2018 03:17:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/replace-a-text-quot-quot-quot-quot-with-quot-quot-in-sas/m-p/517343#M32612 learn_SAS_23 2018-11-30T03:17:22Z Re: replace a text "","" with "," in sas https://communities.sas.com/t5/SAS-Enterprise-Guide/replace-a-text-quot-quot-quot-quot-with-quot-quot-in-sas/m-p/517352#M32613 <P>Use the TRANSTRN function</P> <P>&nbsp;</P> <P><A href="https://documentation.sas.com/?docsetId=lefunctionsref&amp;docsetTarget=n101a8jch5trh0n1bc5neq48hc89.htm&amp;docsetVersion=9.4&amp;locale=en" target="_self">https://documentation.sas.com/?docsetId=lefunctionsref&amp;docsetTarget=n101a8jch5trh0n1bc5neq48hc89.htm&amp;docsetVersion=9.4&amp;locale=en</A></P> <P>&nbsp;</P> <P>Use single quotes to enclose target and replacement strings containing double quotes : '"",""'</P> Fri, 30 Nov 2018 04:26:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/replace-a-text-quot-quot-quot-quot-with-quot-quot-in-sas/m-p/517352#M32613 PGStats 2018-11-30T04:26:44Z Re: replace a text "","" with "," in sas https://communities.sas.com/t5/SAS-Enterprise-Guide/replace-a-text-quot-quot-quot-quot-with-quot-quot-in-sas/m-p/517374#M32614 Thanks Fri, 30 Nov 2018 06:31:17 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/replace-a-text-quot-quot-quot-quot-with-quot-quot-in-sas/m-p/517374#M32614 learn_SAS_23 2018-11-30T06:31:17Z