string split

[daveStudent]

I have a string in the following format

strData = "h:\Folder Name1\FolderName2 Comment About Something"

I would like to split the h:\Folder Name1\FolderName2" from the
"Comment About Something"

Len(strData) >=3

i would like to split strData into strPath and strComment

any help would be greatly appreciated

db

[Armor-Of-God]

Are there only two folders? If so, you could add another \ at the end of folder 2, and use that as a marker. Then, use the Split function, which I'm not very familiar with.

[daveStudent]

there number of folders is also variable

[Stiletto]

Dim Arr() As String
Arr = Split(strData, " ")
MsgBox Arr(0)
MsgBox Arr(1)

You can use this, if your folders will have "_" instead of space.
If you want to keep the space, there are other ways of doing that.

[daveStudent]

Unfortunately the folder names do contain spaces instead of the _ character.

Is there a way of splitting only at the first space after the text directly adjacent to the \

"\Text Split Before the S char"

Result:

"\Text"
"Split Before the S char"

thx
db