How do I use keep the middle string and nothing else?
I have a strong of information that looks like:
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.
Re: How do I use keep the middle string and nothing else?
So all the records within this field will have a similar structure? xxxx-xxxx-xxxx (with xx can vary in number?) If this is the case then Subfield should work for you. If not, then is there any kind of symmetry among the records?