3 Replies Latest reply: Jul 11, 2014 11:54 AM by Jay H RSS

    Parse out text between two identifiers

      Hi,

       

      I'm having a little bit of an issue parsing out text found in between two identifiers (strings)

       

      What I am trying to accomplish is below - for example

       

      I have a string field named resource and it has the following values:

       

      |Wireless Transport|WT-ABC-1505|Process statistics

      |Wireless Transport|WT-ABC-1506|Process statistics

      |Wireless Transport|WT-XYZ-303556|Process statistics
      |Wireless Transport|WT-XYZ-303109|Process statistics

       

      What I want as the result is to extract the data found between |Wireless Transport| and |Process statistics|, however I do not want to include the numerical text as the result. What I would expect the result to be is as below:

       

      WT-ABC

      WT-XYZ

       

      If anyone has any suggestions to parse out this information that would be great!

       

      Thank you in advance.