Reg ex help

[Colin Johnstone]

Gidday list,

Please I need a reg ex to return everything to the left of '\WORKAREA'

in this URL 

$url = 'Y:\default\main\aphrwebAdmin\WORKAREA\Colin'

I tried

$url =~ s/(.*?)[\\WORKAREA]/$1/;

then we wish to remove the drive designation and the leading slash

Thanking you in anticipation

Colin