Results 1 to 3 of 3

Thread: Rich Text

  1. #1
    Join Date
    Oct 2002
    Posts
    61

    Unanswered: Rich Text

    I have a sql database program that has a memo field that contains text that has Rich Text Control Characters embeded into the text. The control characters are at the begining and the end of the field. Is there a way to remove these charatcters?

    Thanks,

  2. #2
    Join Date
    Jan 2003
    Location
    Duncan BC Canada
    Posts
    80
    If your data will fit in within a VARCHAR datatype, try CASTing it to VARCHAR first. Then you can do text manipulation on it. Memo fields won't let you.
    Bradley

  3. #3
    Join Date
    Oct 2002
    Posts
    61

    Rich Text

    I did an analysis of the Rich Text Control Characters and it appears that the ending Characters are "\fs17". I made up the following command that searches the memo field for these characters and then display the remainder of the memo field:

    Mid([SUMMARY],(InStr([SUMMARY],'\fs17')+5))

    Thanks for the information!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •