5 Replies Latest reply on Apr 3, 2019 12:31 PM by Mohammad Rehman

    Extracting text from a string

    Keith Martin
      Share This:

      I have some custom workflow (Active Link) that looks for some text within a character field in the following format within the RUNIF


      'text field' LIKE "%[a-zA-Z][a-zA-Z][0-9][0-9][0-9][0-9][0-9][0-9][a-zA-Z]%" which is a UK NI Number


      If the text is found, it goes on to run the actions within the Active Link.


      This is all fine but I need to capture the text it has found (e.g. RE545656A) and store it in a temporary field/ Anyone got any ideas how I can do this?