1 Reply Latest reply: Dec 30, 2010 9:55 AM by Ehud Nir RSS

Validation Rules: LIKE(text,pattern)

JESÚS MOYA GALINDO
Currently Being Moderated

Hello people.

 

I've a question.

 

Which wildcards can I use in pattern of LIKE function? I know only * (0..n). Iu2019m looking the wildcard for doing 1..n. For it, Iu2019m trying to use +, but it donu2019t works.

 

Could you help me?

 

Regards

  • Re: Validation Rules: LIKE(text,pattern)
    Ehud Nir
    Currently Being Moderated

    Hi,

     

    The LIKE() function is only to define a pattern to be matched against a given string.

    For example -

     

    =LIKE(@BANK_CTRY,"D*")

     

    - returns true for @BANK_CTRY "DE" and false for "US".

    I am under the impression that you are trying to do something that involves numbers, which LIKE() does not support.

     

    Please correct me if I'm wrong,

    Thanks,

    Udi

Actions