t-sql substring

Question

I basically have one column that needs to be substringed. The format of the column looks as follow:

Column A
--------
Root\FOLDERPATH\somesubfolderpath\somedocument.doc

The first string "Root\" will always be the same lengt with same characters. Everything after the "Root\" could vary in lenght depending on the document's folder structure.

What I need to retrieve is the second string. Using the above example, the column should look lilke:

Column A
--------
FOLDERPATH

So I need to cut out the "Root\" obtain the string after this and cut out everything after this.

Alex K. · Accepted Answer · 2011-11-02 15:42:45Z

5

One way:

substring(fld, 6, charindex('\', substring(fld + '\', 6, len(fld))) -1)

answered Nov 2, 2011 at 15:42

Alex K.

177k32 gold badges276 silver badges299 bronze badges

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

Comments

Dave · Accepted Answer · 2011-11-02 15:37:58Z

0

declare @val varchar(100)
set @val = 'Root\FOLDERPATH\somesubfolderpath\somedocument.doc'

select left(right(@val, len(@val) - 5), charindex('\', right(@val, len(@val) - 5)) - 1)

answered Nov 2, 2011 at 15:37

Dave

3,6311 gold badge24 silver badges25 bronze badges

Collectives™ on Stack Overflow

t-sql substring

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related