the problem is and i should have been more specific is the table looks more like this:
c:\path\_____c:\path\path\________c:\path\path\path

the underscores represent spaces.
really it is just the last one with the three paths that is missing the '\'. the other problem is that the path's are not always uniform. it will vary in length throughout this field pending on where i want to point it.
thanks