I'm using a return separated text list for scripted Finds. I use a scripted substitute function as well for the same list.
I'm not sure how to be precise in what is found or replaced. I can think of some convoluted ways to do this with formatting or by having another table, but a simple text field is so fast and easy, it'd be good to be able to keep using it.
A return separated list ... 2 records.
A blue sky
How do I perform a search for Sky, that will only return the 1st record?
How do I script a substitute for Sky, that will only substitute Sky in the 1st record?
In other words ... I only want the Find and Substitute script steps, to consider the values on a 'per line' basis.
(I'm using the =Criteria already, which doesn't achieve what I want)