title: Convert an RTF database field in Firebird to string
body: <p>I am creating a new application and I need to reuse data from the old one. The old one using Firebird as database and Delphi.</p>
  
  <p>The problem is, inside the Firebird database there is a column which contains strange characters. For example:</p>
  
  
  
  <pre class="lang-none prettyprint-override"><code>{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Arial
  Narrow;}{\f1\fnil\fcharset0 MS Sans
  Serif;}}\viewkind4\uc1\pard\lang1033\f0\fs18 11.0 - 16.5\f1\fs16\par}
  </code></pre>
  
  <p>in the application it is displayed as</p>
  
  <blockquote>
    <p>11.0 - 16.5</p>
  </blockquote>
  
  <p>and </p>
  
  <pre class="lang-none prettyprint-override"><code>{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Arial
  Narrow;}{\f1\fnil\fcharset0 MS Sans
  Serif;}}\viewkind4\uc1\pard\lang1033\f0\fs18 3.500 -
  10.000\f1\fs16\par}
  </code></pre>
  
  <p>in application it is displayed as</p>
  
  <blockquote>
    <p>3.500 - 10.000</p>
  </blockquote>
  
  <p>I do not know why the previous developer store the data this way, </p>
  
  <p>How can I pick the string / character that I need, without manually editing the database?</p>