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!

Hi,

 

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, 8.2.2.112), 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

CLEAN(SUBSTITUTE(S12, CHAR(11), ""))

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

 

Michael