SQL Split 2014

Select PARSENAME(replace('/Transport/Bus-Accessories/Air-Conditioning','/','.'), 2)