Converting blob text to formatted text or file

I have a database with table letters. one of the columns in the table is Blobtext(varchar) of this format below . Now i have over 2000 rows in this column . Is there anyway i can convert all blobtext in this table to their respective formatted text or to  files. I suspect these are rtf documents. can i convert blob text to documents or formatted files. i plan on  exporting the converted files or formatted texts as a csv for import later  on . I am just interested on how to do the data conversion with outsystems. Any tip or sample would be immensely appreciated.


{\5crtf1\5cansi\5cansicpg1252\5cuc1\5cdeff0\5cadeff0\5cdeflang0\5cdeflangfe0\5cadeflang0{\5cfonttbl\0d\0a{\5cf0\5cfnil\5cfcharset0\5cfprq2 Arial;}\0d\0a{\5cf1\5cfnil\5cfcharset0\5cfprq0 Arial;}\0d\0a{\5cf2\5cfnil\5cfcharset204\5cfprq0 Arial CYR;}\0d\0a{\5cf3\5cfnil\5cfcharset0\5cfprq0 Tahoma;}\0d\0a{\5cf4\5cfroman\5cfcharset2\5cfprq2 Symbol;}}\0d\0a{\5ccolortbl;\5cred0\5cgreen0\5cblue0;}\0d\0a{\5cstylesheet{\5cs0\5cltrpar\5citap0\5cnowidctlpar\5cql\5cli0\5cri0\5clin0\5crin0\5crtlch\5caf0\5cafs24\5cltrch\5cf0\5cfs24 [Normal];}{\5c*\5ccs10\5cadditive Default Paragraph Font;}}\0d\0a{\5c*\5cgenerator TX_RTF32 20.0.550.501;}\0d\0a\5cpaperw12240\5cpaperh15840\5cmargl1800\5cmargt1440\5cmargr1800\5cmargb1440\5cdeftab1134\5cwidowctrl\5clytexcttp\5cformshade\5csectd\0d\0a\5cheadery720\5cfootery720\5cpgwsxn12240\5cpghsxn15840\5cmarglsxn561\5cmargtsxn232\5cmargrsxn850\5cmargbsxn232\5cpgbrdropt0\5cpard\5cltrpar\5citap0\5cnowidctlpar\5cql\5cli0\5cri0\5clin0\5crin0\5ctx708\5ctx1416\5ctx2124\5ctx2832\5ctx3540\5ctx4248\5ctx4956\5ctx5664\5ctx6372\5ctx7080\5ctx7788\5ctx8496\5ctx9204\5ctx9912\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e004c00650074007400650072002e004400610074006500bb000000}{\5c*\5ctxfieldtext 02 Sep 2015{\5c*\5ctxfieldend}}02 Sep 2015}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a52006500660065007200650065002e00460075006c006c004e0061006d006500bb000000}{\5c*\5ctxfieldtext Dr. XXXXXi{\5c*\5ctxfieldend}}Dr. Alnoor XXXX}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a52006500660065007200650065002e004100640064007200650073007300530074007200650065007400bb000000}{\5c*\5ctxfieldtext 440-2223 Joe St\5cpar Vancouver  BC  V6Z 2K5{\5c*\5ctxfieldend}}440-2223 Joe St\5cpar Vancouver  BC  v7q2K5}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar Ph: \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a52006500660065007200650065002e00500068006f006e0065003100bb000000}{\5c*\5ctxfieldtext 604 688 6332 ext. 225{\5c*\5ctxfieldend}}604 688 6332 ext. 225}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar Fax: \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a52006500660065007200650065002e00460061007800bb000000}{\5c*\5ctxfieldtext 604 689 2004{\5c*\5ctxfieldend}}604 689 2004}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cpar Dear \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a52006500660065007200650065002e005400690074006c006500bb000000}{\5c*\5ctxfieldtext Dr.{\5c*\5ctxfieldend}}Dr.}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a52006500660065007200650065002e004c006100730074004e0061006d006500bb000000}{\5c*\5ctxfieldtext Ramji{\5c*\5ctxfieldend}}Ramji}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033 ,\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpard\5cltrpar\5citap0\5cnowidctlpar\5cql\5cfi708\5cli0\5cri0\5clin0\5crin0\5ctx708\5ctx1416\5ctx2124\5ctx2832\5ctx3540\5ctx4248\5ctx4956\5ctx5664\5ctx6372\5ctx7080\5ctx7788\5ctx8496\5ctx9204\5ctx9912\5cpar\5cpar\5cpard\5cltrpar\5citap0\5cnowidctlpar\5cql\5cfi18\5cli0\5cri0\5clin0\5crin0\5ctx708\5ctx1416\5ctx2124\5ctx2832\5ctx3540\5ctx4248\5ctx4956\5ctx5664\5ctx6372\5ctx7080\5ctx7788\5ctx8496\5ctx9204\5ctx9912\5cplain\5crtlch\5caf2\5cafs26\5calang1033\5cab\5cltrch\5cf2\5cfs26\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb Re:\5cplain\5crtlch\5caf2\5cafs26\5calang1033\5cltrch\5cf2\5cfs26\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ctab\5cplain\5crtlch\5caf2\5cafs26\5calang1033\5cab\5cltrch\5cf2\5cfs26\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00460075006c006c004e0061006d006500bb00\0d\0a0000}{\5c*\5ctxfieldtext Rhodie Jumilla{\5c*\5ctxfieldend}}Rhodie Jumilla}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033 , \5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cab\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb DOB\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033 : \5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e0044006100740065004f006600420069007200\0d\0a74006800bb000000}{\5c*\5ctxfieldtext 13 Dec 1975{\5c*\5ctxfieldend}}13 Dec 1975}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033 , \5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410067006500bb000000}{\5c*\5ctxfieldtext 39y 8m{\5c*\5ctxfieldend}}39y 8m}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cab\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb\5ctab PHN:\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e004e00480049005f004e0075006d0062006500\0d\0a7200bb000000}{\5c*\5ctxfieldtext BC 9762-815-076{\5c*\5ctxfieldend}}BC 9762-815-076}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1\5ctab\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cab\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb\5ccf1 Address:\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410064006400720065007300730053007400\0d\0a72006500650074003100bb000000}{\5c*\5ctxfieldtext 6087 Kerr St.{\5c*\5ctxfieldend}}6087 Kerr St.}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410064006400720065007300730053007400\0d\0a72006500650074003200bb000000}{\5c*\5ctxfieldtext  {\5c*\5ctxfieldend}} }\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410064006400720065007300730053007400\0d\0a72006500650074003300bb000000}{\5c*\5ctxfieldtext Vancouver{\5c*\5ctxfieldend}}Vancouver}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410064006400720065007300730053007400\0d\0a720065006500740053007400610074006500bb000000}{\5c*\5ctxfieldtext BC{\5c*\5ctxfieldend}}BC}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410064006400720065007300730053007400\0d\0a720065006500740043006f0064006500bb000000}{\5c*\5ctxfieldtext V5S 3B6{\5c*\5ctxfieldend}}V5S 3B6}\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1  \5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpard\5cltrpar\5citap0\5cnowidctlpar\5cql\5cfi708\5cli0\5cri0\5clin0\5crin0\5ctx708\5ctx1416\5ctx2124\5ctx2832\5ctx3540\5ctx4248\5ctx4956\5ctx5664\5ctx6372\5ctx7080\5ctx7788\5ctx8496\5ctx9204\5ctx9912  \5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cab\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb Phone:\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033  \5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00500068006f006e0065003100bb000000}{\5c*\5ctxfieldtext 778 892 1275{\5c*\5ctxfieldend}}778 892 1275}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cpard\5cltrpar\5citap0\5cnowidctlpar\5cql\5cli0\5cri0\5clin0\5crin0\5ctx708\5ctx1416\5ctx2124\5ctx2832\5ctx3540\5ctx4248\5ctx4956\5ctx5664\5ctx6372\5ctx7080\5ctx7788\5ctx8496\5ctx9204\5ctx9912\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cab\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb Appointment: \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a4100700070006f0069006e0074006d0065006e0074004400610074006500bb000000}{\5c*\5ctxfieldtext  {\5c*\5ctxfieldend}} }\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a4100700070006f0069006e0074006d0065006e007400540069006d006500bb000000}{\5c*\5ctxfieldtext  {\5c*\5ctxfieldend}} }\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cab\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cab\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb Reason for Referral\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033 :  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a44006900610067006e006f007300690073004400650073006300720069007000740069006f006e00bb000000}{\5c*\5ctxfieldtext Gastritis and duodenitis{\5c*\5ctxfieldend}}Gastritis and duodenitis}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1\5cpar  \5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a4500780070006c0061006e006100740069006f006e00bb000000}{\5c*\5ctxfieldtext Dear Dr. xxx, \5cpar\5cpar Thank you in advance for your expertise in the assessment of this 39yo female's epigastric pain. I am wondering is gastroscopy is warranted?\5cpar\5cpar She has had chronic gastritis symptoms since July 2019 , initially it was acute on chronic as she began suffering in February 2015 after overuse of NSAIDs. In July 2015, she tested positive for H.Pylori, and was treated with the standard Amox/Clarithro/Lansoprozole Hpack, for 7 days. \5cpar She reports that infact she felt better while taking the treatment however, her symptoms returned 4 days later. \5cpar\5cpar Her symptoms improve after eating , otherwise she has  a gnawing pain in her epigastrum usually at 10am and 3:30pm each day, despite being on a PPI, once daily Pantoprazole 40mg. \5cpar\5cpar She has a history of Pulmonary TB , which was treated. \5cpar\5cpar She denies and does not have Ictuerus, Jaundice, Weight loss, Bloody stools, Nausea, Vomiting, Diarrhea. \5cpar\5cpar Her Family History is significant for her maternal Grandmother dying of stomach cancer. \5cpar\5cpar I have sent her for testing including hepatitis, C-19, liver function. I will forward you the results. She will also repeat a 7 day course of Amoxicillin 1000 mg bid and Clarithromycin 500mg bid in the meantime. I have also sent her for an Abdominal Ultrasound to rule out structural and billiary pathology with that.\5cpar\5cpar\5cpar Thank you kindly for your care, \5cpar\5cpar Dr kELL \5cpar MD CCFP{\5c*\5ctxfieldend}}Dear Dr. XXX, \5cpar\5cpar Thank you in advance for your expertise in the assessment of this 39yo female's epigastric pain. I am wondering is gastroscopy is warranted?\5cpar\5cpar She has had chronic gastritis symptoms since July 2015 , initially it was acute on chronic as she began suffering in February 2015 after overuse of NSAIDs. In July 2015, she tested positive for H.Pylori, and was treated with the standard Amox/Clarithro/Lansoprozole Hpack, for 7 days. \5cpar She reports that infact she felt better while taking the treatment however, her symptoms returned 4 days later. \5cpar\5cpar Her symptoms improve after eating , otherwise she has  a gnawing pain in her epigastrum usually at 10am and 3:30pm each day, despite being on a PPI, once daily Pantoprazole 40mg. \5cpar\5cpar She has a history of Pulmonary TB , which was treated. \5cpar\5cpar She denies and does not have Ictuerus, Jaundice, Weight loss, Bloody stools, Nausea, Vomiting, Diarrhea. \5cpar\5cpar Her Family History is significant for her maternal Grandmother dying of stomach cancer. \5cpar\5cpar I have sent her for testing including hepatitis, C-19, liver function. I will forward you the results. She will also repeat a 7 day course of Amoxicillin 1000 mg bid and Clarithromycin 500mg bid in the meantime. I have also sent her for an Abdominal Ultrasound to rule out structural and billiary pathology with that.\5cpar\5cpar\5cpar Thank you kindly for your care, \5cpar\5cpar Dr kELL\5cpar MD CCFP}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cab\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cb Medical Summary \5cpar\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5caul\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cul Problems:\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5caul\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cul\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cacf1\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410063007400690076006500500072006f00\0d\0a62006c0065006d00730044006900610067006e006f00730069007300bb000000}{\5c*\5ctxfieldtext Kyphoscoliosis and scoliosis\5cpar GERD severe life long (triggerd by nsaid Feb 2015)\5cpar July 2015 H Pylori Positive ! Needs Tx- Recalled for same -kg{\5c*\5ctxfieldend}}Kyphoscoliosis and scoliosis\5cpar GERD severe life long (triggerd by nsaid Feb 2015)\5cpar July 2015 H Pylori Positive ! Needs Tx- Recalled for same -kg}\5cplain\5crtlch\5caf3\5cafs16\5calang1033\5cacf1\5cltrch\5cf3\5cfs16\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5ccf1\5cpar\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5caul\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cul Regular Medications:\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5caul\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cul\5cpar\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e0055007300750061006c004d00650064006900\0d\0a63006100740069006f006e00bb000000}{\5c*\5ctxfieldtext 04 Mar 2015 - 29 Dec 2015\5ctab pantoprazole magnesium 40 mg TABLET DR, 1 TABLET DR 1 time a day Oral, 04 Mar 2015, 1 pack of 100 each (tablets, kits, etc.)\5cpar 13 Aug 2015 - 19 Aug 2015\5ctab amoxicillin trihydrate 500 mg, clarithromycin 500 mg, lansoprazole 30 mg COMBO. PKG, 1 COMBO. PKG 2 times a day, 13 Aug 2015, 7 days\5cpar 02 Sep 2015 - 08 Sep 2015\5ctab amoxicillin trihydrate 500 mg CAPSULE, 1 CAPSULE 2 times a day, 02 Sep 2015, 7 days\5cpar 02 Sep 2015 - 08 Sep 2015\5ctab CLARITHROMYCIN 500 MG TABLET, 1 TABLET 2 times a day, 02 Sep 2015, 7 days{\5c*\5ctxfieldend}}04 Mar 2015 - 29 Dec 2015\5ctab pantoprazole magnesium 40 mg TABLET DR, 1 TABLET DR 1 time a day Oral, 04 Mar 2015, 1 pack of 100 each (tablets, kits, etc.)\5cpar 13 Aug 2015 - 19 Aug 2015\5ctab amoxicillin trihydrate 500 mg, clarithromycin 500 mg, lansoprazole 30 mg COMBO. PKG, 1 COMBO. PKG 2 times a day, 13 Aug 2015, 7 days\5cpar 02 Sep 2015 - 08 Sep 2015\5ctab amoxicillin trihydrate 500 mg CAPSULE, 1 CAPSULE 2 times a day, 02 Sep 2015, 7 days\5cpar 02 Sep 2015 - 08 Sep 2015\5ctab CLARITHROMYCIN 500 MG TABLET, 1 TABLET 2 times a day, 02 Sep 2015, 7 days}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5caul\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cul Allergies:\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e00500061007400690065006e0074002e00410063007400690076006500500072006f00\0d\0a62006c0065006d0073004100640076006500720073006500bb000000}{\5c*\5ctxfieldtext No Adverse Reactions known{\5c*\5ctxfieldend}}No Adverse Reactions known}\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033 Your assessment  and recommendations would be appreciated.\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cpar Regards\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033 ,\5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar\5cpar\5cpar\5cpar\5cpar\5cpar\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033{\5ctxfielddef{\5c*\5ctxfieldstart\5ctxfieldtype0\5ctxfieldflags208\5ctxfielddata \0d\0aab004c00650074007400650072002e0043006f006e0074006500780074002e0052006500660065007200720061006c002e00\0d\0a520065006600650072007200650072002e00460075006c006c004e0061006d006500bb000000}{\5c*\5ctxfieldtext Dr. Kat Godlewski{\5c*\5ctxfieldend}}Dr. kell john\5cplain\5crtlch\5caf1\5cafs22\5calang1033\5cltrch\5cf1\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033   \5cplain\5crtlch\5caf2\5cafs22\5calang1033\5cltrch\5cf2\5cfs22\5clang1033\5clangnp1033\5clangfe1033\5clangfenp1033\5cpar\5cpar }

Hello Tmlewin. Indeed these seem to be RTF files. Unfortunately I couldn't find any RTF component on forge...

You could simply download the file, using the download tool and the mime-type of "application/rtf". The user would be able to open the file in MS Word or Wordpad. If you have the file stored as text, you might need to first convert it to binary - there's a BinaryData extension with a TextToBinaryData action that does just that.

If your goal is to process the contents of the file, or display it in the browser, then you will need to find some way to do it in C# and then create an extension in Integration Studio to use that functionality in OutSystems. There are a few nuget packages to process RTF files, some of which claim to convert RTF to HTML - might be easier to process the HTML after that conversion.

leonardo.fernandes wrote:

Hello Tmlewin. Indeed these seem to be RTF files. Unfortunately I couldn't find any RTF component on forge...

You could simply download the file, using the download tool and the mime-type of "application/rtf". The user would be able to open the file in MS Word or Wordpad. If you have the file stored as text, you might need to first convert it to binary - there's a BinaryData extension with a TextToBinaryData action that does just that.

If your goal is to process the contents of the file, or display it in the browser, then you will need to find some way to do it in C# and then create an extension in Integration Studio to use that functionality in OutSystems. There are a few nuget packages to process RTF files, some of which claim to convert RTF to HTML - might be easier to process the HTML after that conversion.

Thanks for the feedback. I am certainly interested in downloading or extracting the files. Now here is the thing, what i pasted here is just one sample file, there are over 900 blob text  files in which each blob text is an rtf file in the  table . Is there anyway i can use the download component as you said to download all the files in the table in bulk, if possible zip them before downloading it because i need the rtf files extracted from the database. i have not used the download component much, can you please elaborate further on how it works in regards to this scenario. Below is a snapshot of the blob text column in the table in my database.


You could use the Zip extension that comes with the platform. That extension allows you to create a Zip file and add files to it. The file is created in memory, and at the end you can get the Zip file as a binary data by using the GetZipBinary action.



Having the binary, then you can use the Download tool to send it to the browser. Check the documentation: https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Implementing_Logic/Web_Logic_Tools/Download

leonardo.fernandes wrote:

You could use the Zip extension that comes with the platform. That extension allows you to create a Zip file and add files to it. The file is created in memory, and at the end you can get the Zip file as a binary data by using the GetZipBinary action.



Having the binary, then you can use the Download tool to send it to the browser. Check the documentation: https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Implementing_Logic/Web_Logic_Tools/Download


Thanks for the help.I have done that already but when i made initial attempts the zip files were empty not containing the rtf files. i can upload a copy of my sample oml so you can see what am trying to achieve.i want to query the blob table and convert all the text files to multiple rtf  files and zip all the files.

I don't see anything creating Zip files on your screen action. Neither do I see a download being used.

Perhaps you've shared the wrong file?

leonardo.fernandes wrote:

I don't see anything creating Zip files on your screen action. Neither do I see a download being used.

Perhaps you've shared the wrong file?

Hi sorry i uploaded an older build. here is the new build. Had to zip because for some weird reason it says invalid type when i attach it directly as oml


I am attaching it here.again . here is the download link https://drive.google.com/open?id=1ai_43wSTDkopX96-l-IWfLi1G9QtWA9s


when i attach directly outsystems site said invalid file , when it an oml. the site is acting weird.Anyway thanks

leonardo.fernandes wrote:

I don't see anything creating Zip files on your screen action. Neither do I see a download being used.

Perhaps you've shared the wrong file?


i have allowed access so you can download the oml. i sent it to you .Thanks

Your code is almost correct. Here's a screenshot of your code for reference (I took the liberty to make this public since you don't have any business logic in this particular action).



A few things you will need to fix:

  1. You want to convert all of your blobs into binary. That means that the TextToBinary will need to be inside the foreach.
  2. The foreach has the connectors in the wrong order. The cycle connector should be pointing to the right, not down in this case. That's the reason why you have that error.
  3. Your download node has FileName = "test.rtf". I hope you realize that your action will output a zip file, so maybe you should change it to "test.zip". Please also change the Mime-Type from "application/rtf" to "application/zip".

I have done as you explained and it download a zip file of 0 bytes. it doesnt contain any rtf file. I don't know why it didn't work. Below is what i did


Try changing the CompressionLevel on CreateZip to a value between 0 and 9. The value you are using (10) is not a valid value, and that might be causing the Zip file to return 0 bytes.