As a transitional step, this site will temporarily be made Read-Only from July 8th until the new community launch. During this time, you can still search and read articles and discussions.

While the community is read-only, if you have questions or issues requiring TIBCO review/response, please access the new TIBCO Community and select "Ask A Question."

You will need to register or log in or register to engage in the new community.

Function CLEAN does not clean up everything!



just noticed that the function CLEAN( ) does not eliminate all invalid characters from a text field. In my case its the character Hex(0b) or CHAR(11) a horizontal tabulator.


CRM 365 on-premise (1612,, CRM adapter 5.5.5 drops those text with an error 384: The field 'notetext' contains one or more invalid characters. That's all.


Needless to say I've already used CLEAN(). To circumvent this, IMO serious flaw, I've now coded this like


, however it's Scribe's job to fix this annoying bug.