We have text fields that we need to validate are numbers. For example, if the v

Mike James

Certified Lead Developer

over 10 years ago

We have text fields that we need to validate are numbers. For example, if the value is "134" or "1456.45" it should pass. but the rule should fail on "TEXT" or "3A5T.57".

Initially, we tried a validation expression like: if(todecimal(ri!textinput)=ri!textinput, true, false) ...however this ran out of usefulness when the text input is greater that 8 characters because Appian starts to round decimals or use scientific notation. So we were failing valid numbers such as "100000.35"

Does anyone have a good way we could perform this validation?

Discussion posts and replies are publicly visible

Top Replies

abhi.jana over 10 years ago +1
Appian Employee

Try - =if(regexmatch("^([0-9.]{1,50})$",ri!input),"Number","Text") Assuming the input is limited to 50 characters. You can further customize the regex pattern to match more specific inputs. The regexmatch…

Parents

0 abhi.jana
Appian Employee
over 10 years ago

Try -
=if(regexmatch("^([0-9.]{1,50})$",ri!input),"Number","Text")

Assuming the input is limited to 50 characters. You can further customize the regex pattern to match more specific inputs.

The regexmatch() function is part of the Appian Regular Expression Functions shared component -
forum.appian.com/.../summary
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 abhi.jana
Appian Employee
over 10 years ago

Try -
=if(regexmatch("^([0-9.]{1,50})$",ri!input),"Number","Text")

Assuming the input is limited to 50 characters. You can further customize the regex pattern to match more specific inputs.

The regexmatch() function is part of the Appian Regular Expression Functions shared component -
forum.appian.com/.../summary
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data