validation

[praveenreddy_bk]

Hi all,

I need a validation for Bank account Number ,it should not contain the ffollowing

1) Alpha numeric

2) -ve number

3) All Zeors,

4) String

5) Special charcaters

Thanks in Advance.

Regards,

Pr

[Former Member]

Hi,

HAS_ALL_CHARS(Bank account Number, "0", "9") AND

LEFT(Bank account Number, LEN(Bank account Number))-0 Not Equal Operator 0

Select the FIELDS, OPERATORS and FUNCTIONS FROM DROP DOWN in Assignment Expression.

Select the Not Equal Operator symbol from OPERATORS DROP DOWN. I am not able to write it down here. So write Not Equal Operator symbol in above expression.

This validation states that your Bank account Number has only NUMERIC values.

It fails for -Ve Number, Alpha numeric number, String, Special Characters and if it has All Zeros.

Other alternative, make this field of Type NUMERIC using MDM console, which will take care of all of your requirement.

Above Expression is working fine at my end.

Kindly revert with the Result and let me know if you have any issue.

Thanks and Regards,

Mandeep Singh