hi
I need to extract data from rtf file and save in sql server column...
Is there any function to achieve the same?
rtf file :-
('{\rtf1\ansi\ansicpg1252\deff0\deflang1030\deflangfe1030{\fonttbl{\f0\froman\fprq2\fcharset0 CG \par \par Times;}{\f1\froman\fcharset0 Times New;}{\f2\froman\fprq2\fcharset0 Times New Roman;}}\par \viewkind4\uc1\pard\nowidctlpar\tx5100\tx6690\f0\fs24 ACCIDENT AND EMERGENCY \par \par \par BROWN,JACKIE 00030110R PROF. G. PAR \par 39 Claremint Gardens 06/11/1928 OP \par MP \par 1805252166 \par \par 08/12/2002 GEB02-46531 L FOOT \par Left foot:- \par there is an oblique fracture through the proximal phalanx of the \par little toe. \par DR. W. BASHIST/TT REPORTED USING VOICE \par Final ID: 196582166 \par 09/12/2002 FOOT GEB02-47831/0003250R \par \par }')