1 2 3 4 5 6 7 8
|
DECLARE @x varchar(500)
SET @x = 'Document 195, Print Document owned by T5346561 on A25LT60706 was printed on A25PRSGR through port secure2. Size in bytes: 188866. Pages printed: 1. No user action is required.'
SELECT @x
, SUBSTRING(@x, CHARINDEX('by', @x) + 3, CHARINDEX('on', @x) - CHARINDEX('by', @x) - 3)
, SUBSTRING(@x, CHARINDEX('on', @x, CHARINDEX('on', @x) + 1) + 3, CHARINDEX('through', @x) - CHARINDEX('on', @x, CHARINDEX('on', @x) + 1) - 3)
, SUBSTRING(@x, CHARINDEX('printed:', @x) + 9, CHARINDEX('. No', @x) - CHARINDEX('printed:', @x) - 9) |
Partager