How can I Strip a string from the middle of another string

[JamesBBB]

Hi All,

I have been trying to manipulate a string to pull out a specific part of the string, basically I have a set of directorys with the same number of path levels, like below

E:\Books\Fiction\Authors
E:\Books\Crime\Authors
E:\Books\Comedy\Authors

What I need to be able to do is pull out "Fiction","Crime","Authors" etc etc as a string.

"E:\Books" and "\Authors" are always the same.

I have tried using Mid, InStrRev etc, but I cannot get the syntax right to pull out the middle of the string as required.

If anyone could please show me how to do this I would be very grateful, as I am completly stuck.

many thanks

James

 

[Golom]

TheType = _
Replace ( Replace ( Path, "E:\Books\", "" ), "\Authors", "" )

 

[SkipVought]

Hi,

Take a look at the Split VB function.

Skip,

_[red][/red]

 

[missinglinq]

Where strPath is your path, i.e. E:\Books\Fiction\Authors or
E:\Books\Crime\Authors or E:\Books\Comedy\Authors and Answer is your book genre:

Answer = Mid(strPath, 10, (Len(strPath) - 17))

will return Fiction or Crime or Comedy.

The Missinglinq

There's ALWAYS more than one way to skin a cat!