Splitting text

[Guest]

I have a a path assigned to a variable like:

Z:\Private\Data_Manager\Cherman_TestMachineName_INV_20070302\InventoryInput\

The length of the path can change, but it will always end in
"InventoryInput\". I'm trying to strip this from my variable so that only the
rest of the path is left.

Any suggestions would be most appreciated!

Thanks,
Clint

 

[Allen Browne]

Since you always want to chop 15 characters off:

Left(strPath, Len(strPath) - 15)