Left ( text ; Length ( text ) - 7 )
Left ( YourField ; Length ( yourfield ) -7 )
Left ( YourField ; Position ( yourfield ; "_" ; 1 ; 1 ) - 1)
The first option assumes that you have exactly 7 characters to strip off in every case. The second option assumes you want to discard all text from the first underscore and onward.