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 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

Reply

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

Children

No Data