Getting Last Value from specific string before Delimeter

SELECT
   mf.name
  ,mf.physical_name
  ,reverse(left(reverse(physical_name), charindex('\', reverse(physical_name)) -1))
 from sys.master_files mf 

where physical_name is your string with delimeter.