i have a path

f:\Data Team\Bureau\A G Barr Soft Drinks\ILabelClient\db.mdb

i would like to cut it to

f:\Data Team\Bureau\A G Barr Soft Drinks\ILabelClient\

the database filename will be of varying lengths so i assume that i need to say "cut everything after the first '\' from the right" unfortunately i have very little idea about hwo to do that.

any help would be most appreciated