Announcement

Collapse
No announcement yet.

REGEX for Validation

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • REGEX for Validation

    I never got a response to this.... so trying again!

    I have a complex formatted field to validate that I use REGEXP to validate normally.

    MM=Month
    DD=Day
    YY=Year
    FFF= First three letters of the first name (* is used to fill empty spaces)
    I=Middle initial (* if not specified)
    LLLL= First 4 letters of last name (* is used to fill empty spaces)

    example: October 17, 1998, John D Roe - would be 101798JOHDROE*

    example: February 29, 2000, Mike Smith - would be 022900MIK*SMIT


    ^(?!023)(?!0229.[13579])(?!0229[02468][26])(?!0229[13579][048])(?!(0[469]|11)31)(0[1-9]|1[012])(0[1-9]|[12][0-9]|3[01])([0-9]{2})(?!.?[*][^*])([a-zA-Z*]{3})[a-zA-Z*](?!.{0,2}[*][^*])([a-zA-Z*]{4})$

    Being new to scriptcase, how do I implement a REGEXP validation inside scriptcase?

    Thanks
Working...
X