instr from the far right questions. 4

[dobe1]

I am trying to to locate the last word in a string. I have a list of street names with suffix, and wish to find the suffixes.

For example in :
St. Marlow CT
Bridgstone Prkwy
John Monroe St

If I were looking for the index of the first space, this would be easy. I would use the following code:
instr(street, " "). I then would use the numeric value provided by the instr function, and use the mid function to parse out the data needed.

The question is, how do I do this from the right?

Dobe

 

[alvechurchdata]

The question is, how do I do this from the right?

Write a For loop which looks at Mid$(street, n, 1) and loops backwards from n=Len(strAddress) to 1.

Remember to Trim the address before testing it - you don't want to detect trailing spaces.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Golom]

Or just use the InStrRev function which does exactly that.

 

[alvechurchdata]

InStrRev

Couldn't remember which version it was introduced. Was it Access 2000?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[PHV]

InStrRev (like Split, Join, Replace, ...) came with office2k.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dobe1]

Thanks,

Your help is appreciated.

DObe