replace " with '

Obsidian | Level 7

How to replace " with ' in marcovariable?

4 REPLIES 4

Calcite | Level 5

Re: replace " with '

Posted 06-13-2012 05:35 AM (1718 views) | In reply to tom12122

tranwrd

Obsidian | Level 7

Posted 06-13-2012 05:46 AM (1718 views) | In reply to MikeTurner

ok, but how use special characters " ' with tranwrd

Tourmaline | Level 20

Posted 06-13-2012 08:34 AM (1718 views) | In reply to tom12122

Try %BQUOTE

Data never sleeps

Super User

Posted 06-13-2012 10:38 PM (1718 views) | In reply to tom12122

EXAMPLE:

%let old= %str( Everyone%" is %"here. old%"s one. ) ;
%let new=%qsysfunc(translate(&old,%str(%'),%str(%")));

%put %bquote(&new);

Ksharp