sql server - Parse file name and path from full path

Question

I need to parse file name and file path from full path using SQL Query.

Eg. Fullpath - SERVERD$EXPORTFILESEXPORT001.csv

FileName        Path
EXPORT001.csv   \SERVERD$EXPORTFILES

Answer 1

Use this -

DECLARE @full_path VARCHAR(1000)
SET @full_path = '\SERVERD$EXPORTFILESEXPORT001.csv'

SELECT LEFT(@full_path,LEN(@full_path) - charindex('',reverse(@full_path),1) + 1) [path], 
       RIGHT(@full_path, CHARINDEX('', REVERSE(@full_path)) -1)  [file_name]