SQL - sGrabBetween (proc) (SubString)

alter procedure sGrabBetween

  @Text as nvarchar(MAX),

  @First as nvarchar(MAX),

  @Second as nvarchar(MAX)

    AS


SELECT SUBSTRING(@Text, CHARINDEX(@First, @Text) + LEN(@First),

                 CHARINDEX(@Second, @Text) - CHARINDEX(@First, @Text) - LEN(@First))



--exec sGrabBetween @Text='Hi there richard',@First='Hi',@Second='ard'

SQL - sGrabBetween (function) (SubString)

create function sGrabBetween

(

  @Text as nvarchar(MAX),

  @First as nvarchar(MAX),

  @Second as nvarchar(MAX)

  )

  RETURNS nvarchar(MAX)

    AS

BEGIN

        RETURN  SUBSTRING(@Text, CHARINDEX(@First, @Text) + LEN(@First),

                 CHARINDEX(@Second, @Text) - CHARINDEX(@First, @Text) - LEN(@First)+1)

 END;

Split String into n- number of characters per line

In this example, it's splitting on 8 characters per line

Dim orig = "12344321678900987"
Dim res = Enumerable.Range(0,orig.Length\8).[Select](Function(i) orig.Substring(i*8,8))

https://stackoverflow.com/questions/8774392/how-to-split-a-string-by-x-amount-of-characters


.