4 Replies Latest reply: Feb 17, 2015 10:42 AM by Andii Toole RSS

    How do I use keep the middle string and nothing else?

      I have a strong of information that looks like:

       

      ON-1055661-1

       

      I want the middle string in order to connect to another database that uses only that part of the data, but I can't figure out how to remove it consistently, since the first and last string can vary greatly. (Not by the number of characters in each, but with what the characters are).

       

      I tried using subfield '-' so that it looked at each string independently, but there is so much clutter now.