Some additional knowledge/information/logic is needed to complete this as djj mentioned, here is some quick code to get you started.
😎
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID('dbo.Webs') IS NULL
BEGIN
Create Table dbo.Webs
(
FullURL nvarchar(255)
);
Insert Into dbo.Webs
Select 'PWA/ENV0103' UNION ALL Select 'PWA/FBP.004' UNION ALL Select 'PWA/IP.CE361886' UNION ALL Select 'PWA/OFS.CE366077' UNION ALL
Select 'PWA/NWK0108' UNION ALL Select 'PWA/TK.2347' UNION ALL Select 'PWA/DRHTest2' UNION ALL Select 'PWA/IDTS.CE363798' UNION ALL
Select 'PWA/or.01795' UNION ALL Select 'PWA/ICT0103' UNION ALL Select 'PWA/OR.00708' UNION ALL Select 'PWA/TS_NetworkProperty_CP01495' UNION ALL
Select 'PWA/CP.01420' UNION ALL Select 'PWA/OR.01378/OR.01391' UNION ALL Select 'PWA/FBP.365113' UNION ALL
Select 'PWA/CP.96xxx';
END
SELECT
W.FullURL
,SUBSTRING(W.FullURL,NULLIF(CHARINDEX('/',W.FullURL,1),0) + 1,LEN(W.FullURL))
FROM dbo.Webs W
Results
FullURL
---------------------------------- ----------------------------
PWA/ENV0103 ENV0103
PWA/FBP.004 FBP.004
PWA/IP.CE361886 IP.CE361886
PWA/OFS.CE366077 OFS.CE366077
PWA/NWK0108 NWK0108
PWA/TK.2347 TK.2347
PWA/DRHTest2 DRHTest2
PWA/IDTS.CE363798 IDTS.CE363798
PWA/or.01795 or.01795
PWA/ICT0103 ICT0103
PWA/OR.00708 OR.00708
PWA/TS_NetworkProperty_CP01495 TS_NetworkProperty_CP01495
PWA/CP.01420 CP.01420
PWA/OR.01378/OR.01391 OR.01378/OR.01391
PWA/FBP.365113 FBP.365113
PWA/CP.96xxx CP.96xxx