Skip to Content
avatar image
Former Member

Validation to avoid special character in material & vendor no

Hi Experts,

We receive material & vendor creation request through E-portal. Once user send request on portal it gets recorde at its backend i.e MDM

Please guide me how to give validation in MDM to avoid special character '*' ',' '&' 'space' in material no. & incase of vendor code these same character & numeric code is not allowed.

Please guide in deatail step by step procedure.

Regards,

Gaurang

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2011 at 03:53 PM

    Hi Gaurang,

    How to give validation in MDM to avoid special character '' ',' '&' 'space' in material no. & incase of vendor code these same character & numeric code is not allowed*

    For this, you can write two validations one for Material number and other for Vendor Code and need to set both of these validations to Automatic Execution = Error

    Expression for Material No as given below:

    IF(FIND(Material No, "*") OR FIND(Material No, ",") OR FIND(Material No, "&") OR FIND(Material No, " ") , FALSE, TRUE)

    Expression for Vendor Code as given below:

    IF(FIND(Vendor Code, "*") OR FIND(Vendor Code, ",") OR FIND(Vendor Code, "&") OR FIND(Vendor Code, " ") , FALSE, TRUE)

    So both above validations will fail if they find any Special character among Asterisk ("*"), Ampersand ("&"), Space (" ") and Comma (","). Kindly revert with result.

    Regards,

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Gaurang,

      Please guide me to give validation to stop numerical code.

      HAS_ALL_CHARS(Vendor Code, "A", "z") OR FIND(Vendor Code, "-")

      Above Validation allows only Characters no special chars except "-" and also no numeric numbers.

      Regards,

      Mandeep Saini

  • avatar image
    Former Member
    Jan 03, 2011 at 05:23 AM

    Hi Gaurang,

    Material :

    FIND(Material Number,'&','*') - Special characters Validation

    IF(FIND(Material Number,","," ") - Validation on "," and "Space"

    Vendor:

    FIND(Vendor,'&','*') - Special characters Validation

    IF(FIND(Material Number,","," ") - Validation on "," and "Space"

    IF(HAS_ANY_CHARS(Vendor,0,9),FALSE,TRUE) - Validation for restricting Numeric Codes

    Hope this helps you, and lets see if any workaround from experts.

    Thanks

    Sowseel

    Edited by: sowseel pasumarthi on Jan 3, 2011 6:53 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2011 at 11:39 AM

    Validation to avoid special character in material & vendor no

    Add comment
    10|10000 characters needed characters exceeded