5 Replies Latest reply on Nov 21, 2014 11:21 AM by philmodjunk

    Determine if the Field Contains a Specific Character

    FrankPetrallo

      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