How to split string by forward slash in SQL Server? [duplicate]

Question

There is no default split function in SQL Server 2012 that I'm using.

I want to split the string (ex: /Folder1/Folder2/) by /.

if string is /Folder1/ then output should be Folder1,
if string is /Folder1/Folder2/ then output should be Folder2,
if string is /Folder1/Folder2/Folder3/ then output should be Folder3.

A combination of the REVERSE, CHARINDEX, and SUBSTRING functions will get you there. — TT.
– TT., Commented Sep 30, 2018 at 9:29
This question has been answered before in many different flavours: stackoverflow.com/questions/2647/… — Alex
– Alex, Commented Sep 30, 2018 at 9:35
@TT I found the answer with your help SELECT REVERSE(SUBSTRING(SUBSTRING(REVERSE('/Folder1/Folder2/'),2,len(REVERSE('/Folder1/Folder2/'))),1,charIndex('/',SUBSTRING(REVERSE('/Folder1/Folder2/'),2,len(REVERSE('/Folder1/Folder2/'))))-1)) — Liam neesan
– Liam neesan, Commented Sep 30, 2018 at 9:43

Michał Turczyn · Accepted Answer · 2018-09-30 09:36:55Z

1

Try this:

declare @tbl table (path varchar(100));
insert into @tbl values
('/Folder1/'),
('/Folder1/Folder2/'),
('/Folder1/Folder2/Folder3/');

select *, 
       replace(substring(path, len(path) - charindex('/', reverse(path), 2) + 1, 1000), '/', '')
from @tbl

answered Sep 30, 2018 at 9:36

Michał Turczyn

41.2k18 gold badges58 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

How to split string by forward slash in SQL Server? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related