Repalce in Regular expression with item text

I am going to just do the first step for you the second step must be a function that i am going to reference and i am sure that you can make it your self

good luck

step 1

DECLARE @tblXyz Table (IdName Nvarchar(20) , nValue Nvarchar(20) )

DECLARE @str nVarChar(200) = 'id1-1,2 ; id2-1,3 ; id3-4,9 ; id4-2,6'

SELECT @str

INSERT INTO @tblXyz

SELECT [IdName] = RTrim(LTrim(Substring([Value] , 0 , CHARINDEX('-' , [value]))))

, [nValue] = REPLACE(Substring([Value] , CHARINDEX('-' , [value])+1 , LEN([Value])) , ' ' , '')

--, *

FROM string_split (@str , ';')

SELECT * FROM @tblXyz

Step 2

create a function like ...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/678366ed-3d48-4778-bc9a-4bf50b394032/split-string-into-multiple-rows-with-position-id?forum=transactsql

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
I am going to just do the first step for you the second step must be a function that i am going to reference and i am sure that you can make it your self
good luck

step 1

DECLARE @tblXyz Table (IdName Nvarchar(20) , nValue Nvarchar(20) )
DECLARE @str nVarChar(200) = 'id1-1,2 ; id2-1,3 ; id3-4,9 ; id4-2,6'
SELECT @str
INSERT INTO @tblXyz
SELECT [IdName] = RTrim(LTrim(Substring([Value] , 0 , CHARINDEX('-' , [value]))))
, [nValue] = REPLACE(Substring([Value] , CHARINDEX('-' , [value])+1 , LEN([Value])) , ' ' , '')
--, *
FROM string_split (@str , ';')
SELECT * FROM @tblXyz

Step 2
create a function like ...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/678366ed-3d48-4778-bc9a-4bf50b394032/split-string-into-multiple-rows-with-position-id?forum=transactsql
Nanddeep Nachan8y ago
1. SELECT * FROM YourTable WHERE SomeField LIKE 'id[0-9]-[0-9],[0-9]'