4 Replies Latest reply: Oct 31, 2017 7:50 PM by Saran De RSS

    Using WildMatch in an IF function?

    Erica Trotter

      Hi Everyone,

       

      I am working to create two new field based on a id

      The ID looks like this:

      123-16

      234-17

      556P

      345P

      234-15

      I would like to create an if statement in the script that separates the P from the -##, but I haven't been able to get it to load. I want the "P" to be named primary, and the -## to be named historical. 

       

      if you can help I would appreciate it!