Skip to main content
Solved

Converting the stickynote CLOB readable text

  • July 2, 2026
  • 2 replies
  • 12 views
J
Hero (Customer)
Forum|alt.badge.img+10

Hi,

 

We have just upgraded from Apps10 to CLoud.  Cloud no longer has a sticky note feature, I am trying to find the best way to convert the data held in the table to readable text.  My hope is to create a custom field on the table and then populate it with the data.  However when I try to convert I am getting the following in the field.

 

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Trebuchet MS;}}\viewkind4\uc1\pard\lang2057\f0\fs20 new PO has been created\par\parplease see \fs20 E200049\lang1033\par}

 

What is the best way to get the actual text ?

Best answer by dsj

Hi ​@JannetteC 

Sticky notes are stored in rich text format and that’s why you are seeing the formatted text like this.

If you only have plain text content on the sticky notes, then you could build a text parser to extract the text from the note.

Otherwise, there are few options available.

Cheers!

Damith

2 replies

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Ultimate Hero (Partner)
  • Answer
  • July 3, 2026

Hi ​@JannetteC 

Sticky notes are stored in rich text format and that’s why you are seeing the formatted text like this.

If you only have plain text content on the sticky notes, then you could build a text parser to extract the text from the note.

Otherwise, there are few options available.

Cheers!

Damith

DSJ - https://dsj23.me
J
Hero (Customer)
Forum|alt.badge.img+10
  • JannetteC
  • Author
  • Hero (Customer)
  • July 3, 2026

Thanks @dsj , that’s perfect

Terms & ConditionsAccessibility statement