Jose,

The format is RTF (rich text format). You can use the following to convert it to plain text -

lortf=CREATEOBJECT("richtext.richtextctrl")
lortf.TextRTF = myRTFtextfield
m.lcPlainText = lortf.Text

-Dan

>hello how are you, I have the following problem I am migrating a database from SQL Server to mysql but data type
>in text fields have something I do not know
>
>{\rtf1{\colortbl;\red0\green0\blue255;}
>\cf1 Primera Consulta [21/08/2006]\par
>\cf0\par
>\par
>\par\par}
>
>and I just want to migrate the data string 'Primera Consulta [21/08/2006]'