AnsweredAssumed Answered

Function Help - Maybe Pattern?

Question asked by matttandy on Mar 10, 2012
Latest reply on Mar 11, 2012 by g@briellelevenson

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!

 

Matt

Outcomes