Trim Text based on value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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], "%"))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IIF AND statements 4
Unable to append due to key violations 1
Replace a value with the one above it in a field 6
Query Help Please 3
Rounding to the Left of the Decimal 1
Counting Missing values in a specific field. 1
Dlookup a range with multiple criteria 7
Why can't I do this? 4

Back
Top