April 22, 201015 yr 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!
April 22, 201015 yr Author I've found a custom function that meets my need: http://www.briandunning.com/cf/1114
Create an account or sign in to comment