Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION [dbo].[fn_SplitText]
- (
- @RowData NVARCHAR(MAX),
- @Delimeter NVARCHAR(MAX)
- )
- RETURNS @RtnValue TABLE
- (
- ID INT IDENTITY(1,1),
- DATA NVARCHAR(MAX)
- )
- AS
- BEGIN
- DECLARE @Iterator INT
- SET @Iterator = 1
- DECLARE @FoundIndex INT
- SET @FoundIndex = CHARINDEX(@Delimeter,@RowData)
- WHILE (@FoundIndex>0)
- BEGIN
- INSERT INTO @RtnValue (DATA)
- SELECT
- DATA = LTRIM(RTRIM(SUBSTRING(@RowData, 1, @FoundIndex - 1)))
- SET @RowData = SUBSTRING(@RowData,
- @FoundIndex + DATALENGTH(@Delimeter) / 2,
- LEN(@RowData))
- SET @Iterator = @Iterator + 1
- SET @FoundIndex = CHARINDEX(@Delimeter, @RowData)
- END
- INSERT INTO @RtnValue (DATA)
- SELECT DATA = LTRIM(RTRIM(@RowData))
- RETURN
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement