2 Replies Latest reply: May 25, 2012 4:52 PM by Erich Shiino RSS

    Validate fields formats to find exceptions



      I have data fields that have been input and want to try and make an exception report that will pull any fields that are not part of a specific format.


      The format that each field should be will be 2xletters followed by 6xnumbers. LLNNNNNN.

      Each field should be 8 chars long.

      The 2 letters should be only certain combinations, eg. AA, AB but not LL, LS, etc.


      Please can you explain the best way of doing this, is it as an expression in a chart?