5 Replies Latest reply on Oct 13, 2010 2:34 PM by sunmoonstar.13

    get all text before character



      get all text before character


      I need to take a database field and pull out with a calculation all words/characters before the occurance of a hyphen.

      I am thinking this will begin with Left ( text ; numberOfCharacters ) then determine the space from the left that the hyphen falls but this is where I am stuck.

      I should add that sometimes the desired result will be a single number but sometimes it may be a number and some text. Maybe Left() is not going to work.