Hello! I am a long time FM PRO user, but limited in function building using anything outside of the easier ones. I need to extract info from the following sample data:
Save $1 on 1 steak sauce 10oz+
Save $1 on 1 bar 5pk Save $1 on 1 shake 4pk
Save $1 on 1 Ears treats Foot, Fruit Gushers, Fruit Roll-Ups
|Save $.50 on 2 Fruit Shapes, Fruit by the|
These are coupons typed into one field and I need to separate the amount saved ($1) into one field and the qty (1) in another field. The pattern is the same - Save $xx "ON" xx.
I know most of you can do this in your sleep. Please give me a starting point. I'm thinking PatternCount or maybe Middle.
Thanks for your help!