[AccessD] Last occurrence within a string

ACTEBS actebs at actebs.com.au
Tue Oct 26 09:27:42 CDT 2004


Chris,

You're a star!...

Thanx muchly
Vlad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mackin,
Christopher
Sent: Wednesday, 27 October 2004 12:11 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Last occurrence within a string


InstrRev("C:\MyDocs\Docs\Temps\Hello.doc", "\")

will get it for you.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of ACTEBS
Sent: Tuesday, October 26, 2004 8:08 AM
To: Access Group (E-mail)
Subject: [AccessD] Last occurrence within a string


Guys,

I am stuffing around with this and am sure I have done this before but for the life of me can't get it. I need to find the last occurrence of "\" within a file path string. For example if the path was C:\MyDocs\Docs\Temps\Hello.doc I want to be able to return the Hello.doc portion and to do that obviously I need to know what position the last backslash is.

Any ideas?

Vlad
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list