AnsweredAssumed Answered

Determine if the Field Contains a Specific Character

Question asked by FrankPetrallo on Nov 17, 2014
Latest reply on Nov 21, 2014 by philmodjunk

Title

Determine if the Field Contains a Specific Character

Post

I can not Get this in my Head. I have a Field that Contains A Value Similar to This
 
 2x      @5.99

Of Course the 2x can be 100x and the $5.99 Can be $100.99 I Want to Look at this Field and If The Data in this Field looks Like this, I want to be able to Select the 2 (or Whatever it is) and Copy it to a Feild in another table

If I Use Left() it is only Vaild when It equals exactly what I use, Im not getting how to Look at Just the x, Then Select the Number directly to The Left of it..
Again My Problem is How I Determine that This is the Field I want to Select from.
Thank  You

Outcomes