Hi all, One of my users managed it to enter some Unicode control chars (spe

shelzle over 10 years ago

Hi all,
One of my users managed it to enter some Unicode control chars (specifically "SOH" which is char(1)) into a field. Now my rule to display HTML on a dashboard using textfromtemplate breaks with an error that the template document is invalid. Trying to remove these chars from the text with substitute("dummy " & char(1) & " text", char(1), "") does not work.

Any ideas?...

Discussion posts and replies are publicly visible

0 shelzle over 10 years ago

Never mind. Problem solved. clean() is the way to go. Had to go through several layers of rules....
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shelzle over 10 years ago

Follow up to this: clean() also removes german umlauts. Is there a OOTB function that does "the right thing" or do I have to build an expression like this

stripwith(ri!text_to_clean, joinarray(char({1,2,3,4,5,6,7,8,9,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,127})))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 peterh over 9 years ago

I've run into the same issue, did you ever find a better workaround?
And how did you come up with that list of char codes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel