1 2 Previous Next 20 Replies Latest reply on Jan 17, 2020 2:49 PM by Gerardo Varela

    Filter Regex

    Gabriel Simmons

      Hello community, I wish you success and encouragement for your great effort that each one brings to the community that I liked very much are very active.
      I need help regarding the next workbook that I attach; I must identify the foreigners of the nationals and the only way there is by their identification number
      Nationals have the following structure

       

      1 – 13 – xxx -xxxx

      PE-XXXX-XXXX

      E-XXXX-XXXX

      N-XXX-XXXX

      1-13AV-XXXX

      PI-XXXX-XXXX

      1-13PI-XXXX-XXXX

       

      The numbers 1-13 are a range that corresponds to the states, and everyone who does not have this structure is foreign by their passport number

      Also, I'm afraid I have null fields and I don't know if it will affect the time of the calculated field

      Any suggestions on how to address this classification

      Thank you very much for your time

        1 2 Previous Next