Validating for digits

Question

I have a text field that has to be digits only, is there a way to validate this field in SAIL? I have tried using the isnull(tointeger()) functions, but this only works if the whole input is letters not a mix of digits and letters.

Carlos Santander · Accepted Answer

You can use a!integerField() . If you absolutely need to use a text field, you can use cleanwith or stripwith on the actual text in order to perform validations or to sanitize user input.

Colton Beck · Answer

Why not use an integer or decimal field component, instead of a text field? This will automatically throw a validation message if any non-numerical characters are input. 
 
Otherwise, I'd recommend using the stripwith() function to dynamically remove any prohibited characters from the field.

Validating for digits

Top Replies