Trim Text based on value

R

Richard Cevat

I have a table with bill_to_customer_class_meaning
The records include names like
reseller 30% discount
reseller 35% discount
end user
end user 5% discount

I want a querey to trim of the number % discount
 
K

Ken Snell [MVP]

Try this expression (all one line even though newsreader will wrap it onto
multiple lines):

Trim(Left([bill_to_customer_class_meaning],
InStrRev([bill_to_customer_class_meaning], " ",
InStr([bill_to_customer_class_meaning], "%"))))
 
Top