search text for duplicate values

[Neuronal Nerd]

Hello, I'm trying to create a custom function that will search a text field for all duplicate phrases that start with a particular character (i.e., "{") and ends with a particular character (i.e., ":") and output a list of those.

For example, if my text is:

"{Memory: The patient's memory was measured in the above average range for visual stimuli.

{Memory: On memory tests involving auditory stimuli, the patient's performance was impaired. "

Then I would like the custom function to output: "{Memory"

My reasoning for wanting to do this is difficult to explain, but basically it is part of a larger custom function that reorganizes reports based on headers that are already consistently marked with the a "{" at the beginning and a ":" at the end.

Thanks for the help!

[Neuronal Nerd]

I've found a custom function that meets my need: http://www.briandunning.com/cf/1114