Hi All:
This is my first post...
I need to extract data (that is different in all cases, see below) from between two sets of data that appear anywhere within a single field and copy it to another field.
For example, I have a field called SecondLine and here is the full data value for three of its records:
Hello my name is Rudeamy and I love the color orange.
Hey everyone, my name is Fred and I love the color red, but I also like purple.
Howdy, my name is Julia and I love the color lavender.
I need the data between "my name is" and "color" to appear in another field, called FirstLine.
(This isn't really the data I need to extract, but I think its an appropriate substitution.)
Any suggestions are greatly appreciated.
Amy