Find Path of the file using substring

Question

I have list of file path stored in a column of a table. Now I need to extract only till last '\' in file path (i.e like below result set) Example:

column_A
--------------
G:\REPORTS\DDMS\PCP0.txt
G:\REPORTS\DPS\DEFAU.pdf

Result

G:\REPORTS\DDMS\
G:\REPORTS\DPS\

Pரதீப் · Accepted Answer · 2015-01-22 10:02:41Z

3

Try this.

DECLARE @str VARCHAR(500)='G:\REPORTS\DDMS\PCP0.txt'

SELECT Reverse(Substring(Reverse(@str), Charindex('\', Reverse(@str)), Len(@str)))

answered Jan 22, 2015 at 10:02

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Randy Castleberry · Accepted Answer · 2015-01-22 10:04:38Z

0

answered Jan 22, 2015 at 10:04

Randy Castleberry

565 bronze badges

.Net is available in SQL Server and this kind or processing is arguably done best in SQLCLR.

StackUser · Accepted Answer · 2015-01-22 10:45:22Z

0

Try this

DECLARE @str VARCHAR(500)='G:\REPORTS\DDMS\PCP0.txt'

SELECT LEFT(@str, len(@str) - CHARINDEX('\', REVERSE(@str)))

answered Jan 22, 2015 at 10:45

StackUser

5,3983 gold badges29 silver badges48 bronze badges