AnsweredAssumed Answered

get all text before character

Question asked by gsainc on Oct 12, 2010
Latest reply on Oct 13, 2010 by sunmoonstar.13


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.