1 2 3 4 5 6 7 8
|
DECLARE @TEXt varchar(max) ='92K alli2/ESTP01023/PROD/PROD_TRAITE/P_AZBMW_BAZP01023_20140803_183048963327.xml'
SELECT @TEXT
SELECT SUBSTRING(@TEXT,1,PATINDEX('%[A-Z]%',@TEXT)) as size ,
case when isnull(LEFT( RIGHT( @TEXT, LEN( @TEXT ) - CHARINDEX( '/',@TEXT, 0 ) ), CHARINDEX( '/', RIGHT(@TEXT, LEN(@TEXT) - CHARINDEX( '/', @TEXT, 0 ) ), 0 ) ),'')='' then ''
else LEFT( RIGHT( @TEXT, LEN( @TEXT ) - CHARINDEX( '/',@TEXT, 0 ) ), CHARINDEX( '/', RIGHT(@TEXT, LEN(@TEXT) - CHARINDEX( '/', @TEXT, 0 ) ), 0 ) -1 )
end ,
right(@TEXT, charindex('/', reverse(@TEXT) + '/') - 1) |
Partager