we have a scenario where the user can enter the special characters in one of t

rajashekarv over 9 years ago

we have a scenario where the user can enter the special characters in one of the fields through the excel upload option we have on our app , these characters are treated well in the Appian ,but when we try to insert the data with these special Characters into the database we get an exception .
Is there a way in Appian to escape all these special characters before we insert into DB ?

Discussion posts and replies are publicly visible

0 harshav over 9 years ago

May be you can try some Text functions like Stripwith,substitute .... for each variable by writing some apply functions... Not sure you have seen these but attaching this for your reference
forum.appian.com/.../Text_Functions.html
Hope this would Help !!! :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 9 years ago

A well configured DB should not have problems with any character. Is the DB set to unicode?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Schmitt
Certified Lead Developer
over 9 years ago

I had a case where a user pasted some formatting character into a paragraph field (my guess is that it was a weird bullet point, copied out of a Word document), which caused a failure during the Write to DS. This environment is cloud-based and the DB is utf8 unicode. It's only happened once in over a year in production, so there's that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 9 years ago

If stripwith() etc doesnt' work, you could also use the regex replace plugin functions to replace anything that's not within a particular set of characters.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel