need to remove the 'a' from 10a and 234a in a table field

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

Guest

I want to locate the 'a' and 'b' in strings (ex 10a and 234b) and remove the
letters.

thanks
doug
 
Hi Doug,

This will remove them for you...

replace(replace(STRING_TO_REMOVE_ITEMS, "a", ""), "b", "")

Hope this helps.

Damian.
 
You must log in or register to reply here.

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

need to remove part of a string 3
Access to MySQL conversion 2
format cells in degrees & minutes of arc 1
Sorting 7
Return Bottom Values 12
Group Header Sorting 2
VBA to highlight cells 5
Multiple values in criteria field 2

Back
Top