cancel
Showing results for 
Search instead for 
Did you mean: 

How to prevent special characters in a field

Grill Chef
Grill Chef

How to prevent special characters in a field

I would like to prevent special characters from being entered into a text field in an SFM.

Is there a function that I can use to do this on the Data Validation tab or does anyone have a clever way of doing this?

Message 1 of 3
2 Replies
Pastry Chef
Pastry Chef

Re: How to prevent special characters in a field

Hello Gill Cook​. You might try using an SFM Validation rule to check for special characters using the CONTAINS function. I think you can have up to (15) expressions per SMax Support.

sfm validations​ sfm data validation rule​ sfm​ data_integrity​

Message 2 of 3
Pastry Chef
Pastry Chef

Re: How to prevent special characters in a field

May have to add the characters in singe quotes to make this work:   '%'    '#'     '!'

Message 3 of 3
0 Likes
Reply