https://community.sap.com/t5/application-development-and-automation-discussions/converting-rtf-from-ms-sql-database-to-plain-text-in-abap/m-p/8011521#M1607743 <HTML><HEAD></HEAD><BODY><P>We are selecting data from an external MS SQL database into an internal table using ABAP. The data for the text field is coming out in the format below.</P><P></P><P>u2018{\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 Tahoma;}} {\*\generator Msftedit 5.41.21.2510;}\viewkind4\uc1\pard\f0\fs17 dsfdsgds gsgsdfgf\par }u2019 </P><P></P><P>Does anyone know if there is a way in ABAP to convert this text into a readable format?</P><P></P><P>We want the text from this field to used in BAPI_PO_CREATE1 as the poitem-SHORT_TEXT.</P><P></P><P>Thank you</P><P>Karen</P></BODY></HTML> Mon, 08 Aug 2011 13:25:04 GMT former_member498918 2011-08-08T13:25:04Z https://community.sap.com/t5/application-development-and-automation-discussions/converting-rtf-from-ms-sql-database-to-plain-text-in-abap/m-p/8011521#M1607743 <HTML><HEAD></HEAD><BODY><P>We are selecting data from an external MS SQL database into an internal table using ABAP. The data for the text field is coming out in the format below.</P><P></P><P>u2018{\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 Tahoma;}} {\*\generator Msftedit 5.41.21.2510;}\viewkind4\uc1\pard\f0\fs17 dsfdsgds gsgsdfgf\par }u2019 </P><P></P><P>Does anyone know if there is a way in ABAP to convert this text into a readable format?</P><P></P><P>We want the text from this field to used in BAPI_PO_CREATE1 as the poitem-SHORT_TEXT.</P><P></P><P>Thank you</P><P>Karen</P></BODY></HTML> Mon, 08 Aug 2011 13:25:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/converting-rtf-from-ms-sql-database-to-plain-text-in-abap/m-p/8011521#M1607743 former_member498918 2011-08-08T13:25:04Z https://community.sap.com/t5/application-development-and-automation-discussions/converting-rtf-from-ms-sql-database-to-plain-text-in-abap/m-p/8011522#M1607744 <HTML><HEAD></HEAD><BODY><P>Hi Karen,</P><P></P><P>This should work:</P><PRE><CODE> DATA l_string TYPE string. l_string = '{\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 Tahoma;}}' &amp;' {\*\generator Msftedit 5.41.21.2510;}\viewkind4\uc1\pard\f0\fs17 dsfdsgds gsgsdfgf\par }'. DATA lt_tline TYPE TABLE OF tline. DATA lt_rtf TYPE tdtab_x256. DATA l_size TYPE i. CALL FUNCTION 'SCMS_STRING_TO_FTEXT' EXPORTING text = l_string IMPORTING length = l_size TABLES ftext_tab = lt_rtf. DATA ls_thead TYPE thead. CALL FUNCTION 'CONVERT_RTF_TO_ITF' EXPORTING header = ls_thead x_datatab = lt_rtf x_size = l_size TABLES itf_lines = lt_tline EXCEPTIONS invalid_tabletype = 1 missing_size = 2 OTHERS = 3. DATA lt_string TYPE TABLE OF string. CALL FUNCTION 'CONVERT_ITF_TO_STREAM_TEXT' EXPORTING lf = 'X' IMPORTING stream_lines = lt_string[] TABLES itf_text = lt_tline. DESCRIBE TABLE lt_string. ASSERT sy-tfill = 1. DATA l_result TYPE string. READ TABLE lt_string INDEX 1 INTO l_result. ASSERT l_result = ' dsfdsgds gsgsdfgf'. </CODE></PRE><P>Note that the SAP function module returns an incorrect leading space, that you can easily remove.</P><P></P><P>Best regards,</P><P>Sandra</P></BODY></HTML> Wed, 10 Aug 2011 22:06:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/converting-rtf-from-ms-sql-database-to-plain-text-in-abap/m-p/8011522#M1607744 Sandra_Rossi 2011-08-10T22:06:38Z