https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300173#M63374 <P>If you mean something other than the RTF codes best might be to save the file as <EM><U><STRONG>plain Text</STRONG> </U></EM>and remove all of the formatting and appearance information.</P> <P>Then read the resulting text file.</P> Thu, 22 Sep 2016 19:51:24 GMT ballardw 2016-09-22T19:51:24Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300169#M63373 <P>I have a text variable like the following. How can I extract the&nbsp;useful&nbsp;information that I need? Thanks.</P> <P>&nbsp;</P> <DIV class="branch"> <DIV> <DIV align="center"> <TABLE class="table" summary="Procedure SQL: Query Results" frame="box" rules="all" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="l data"> <P>{\rtf1\ansi\ansicpg1252\uc0\deff1{\fonttbl {\f0\fswiss\fcharset0\fprq2 Arial;} {\f1\froman\fcharset0\fprq2 Times New Roman;} {\f2\froman\fcharset2\fprq2 Symbol;}} {\colortbl;\red0\green0\blue0;\red255\green255\blue255;\red255\green0\blue0;} {\stylesheet{\s0\f1\fs20 Normal;}{\*\cs10\additive Default Paragraph Font;}{\s16\f0\fs24 [Normal];}{\s17\sa120\f1\fs20\sbasedon0 Body Text;}{\s18\qc\sb360\sa240\f0\fs20\b\sbasedon0\snext0 heading 1;}} {\*\listtable{\list\listtemplateid1\listsimple{\listlevel\levelnfc0\leveljc0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'00\'2e;}{\levelnumbers\'01;}\f1\fs24\b0\i0\strike0\ul0\cf0\cb0\fi-360\li821}{\listname ;}\listid1}} {\*\listoverridetable{\listoverride\listid1\listoverridecount0\ls1}} {\*\generator TX_RTF32 9.1.312.500;} \deftab1134\paperw12240\paperh15840\margl2592\margt3888\margr1138\margb1138\pard\s17\sl480\slmult1\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\tx9360\tx10080\plain\f1\fs24\cf3 &lt;CERTIFIED MAIL #&gt; &lt;HAND DELIVERY&gt; \par\pard\s17\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\tx9360\tx10080\plain\f1\fs24 [Today in Words()]\par\par [Admin. 1st Name (Frank)()] [Admin. Last name (Smith)()], Administrator\parhe facility received an \loch\f1\hich\f1 \'93A\'94 during its survey,...</P> <P>&nbsp;</P> </TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> Thu, 22 Sep 2016 17:42:14 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300169#M63373 Yurie 2016-09-22T17:42:14Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300173#M63374 <P>If you mean something other than the RTF codes best might be to save the file as <EM><U><STRONG>plain Text</STRONG> </U></EM>and remove all of the formatting and appearance information.</P> <P>Then read the resulting text file.</P> Thu, 22 Sep 2016 19:51:24 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300173#M63374 ballardw 2016-09-22T19:51:24Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300176#M63375 <P>Thanks. I saved it in .rtf (word document). However, I do not know how to remove those strange symbols and letters. When I open the file, those rtf codes are still there. Any suggestions will greatly appreciated.&nbsp;</P> Thu, 22 Sep 2016 17:59:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300176#M63375 Yurie 2016-09-22T17:59:04Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300179#M63376 <P>Save as txt instead of RTF.&nbsp;</P> Thu, 22 Sep 2016 18:26:52 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300179#M63376 Reeza 2016-09-22T18:26:52Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300201#M63386 <P>RTF is not plain text as you see.</P> Thu, 22 Sep 2016 19:52:07 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300201#M63386 ballardw 2016-09-22T19:52:07Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300422#M63451 <P>Thanks. I tried to save it as .txt file.&nbsp;When I open it again, it shows extactly what I save there. I am wondering do I need some code to extract the right informaiton, or anyting else?&nbsp;</P> Fri, 23 Sep 2016 15:57:08 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300422#M63451 Yurie 2016-09-23T15:57:08Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300435#M63454 <P>You opened rhe file in Word and then saved as a txt file? That should have stripped the RTF tags.&nbsp;</P> Fri, 23 Sep 2016 16:27:32 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-the-correct-information-from-the-rtf-text/m-p/300435#M63454 Reeza 2016-09-23T16:27:32Z