Trim various characters from a query field

in 3 stages, how can I Trim the following:

1. 394 High Street (remove the numbers, which will vary in length, but will always be numbers)

2. High Street/Main Street/Any Street
(remove everything beyond, and including the first /)

3. - (remove just the dash)

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Answer

Try:

StreetName: Right([OriginalAddress],Len([OriginalAddress])-InStr([OriginalAddress]," "))

Daniel Pineault, 2010-2011 Microsoft MVP
http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

--
Daniel Pineault
Microsoft MVP 2010-2021

1 person found this reply helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Replies (8)

Last updated October 5, 2021 Views 3,758 Applies to: