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

Parents

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

Reply

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

Children

No Data