从完整路径解析文件名和路径 [英] Parse file name and path from full path

问题描述

我需要使用 SQL 查询从完整路径解析文件名和文件路径.

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

例如.完整路径 - \SERVER\D$\EXPORTFILES\EXPORT001.csv

FileName        Path
EXPORT001.csv   \\SERVER\D$\EXPORTFILES\

推荐答案

使用这个 -

DECLARE @full_path VARCHAR(1000)
SET @full_path = '\\SERVER\D$\EXPORTFILES\EXPORT001.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]

这篇关于从完整路径解析文件名和路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！