How to replace sub string by stuff separated by stick | to separate values?

Question

I work on SQL server 2012 I face issue I can't separate values by stick | using stuff ?

meaning i need to replace sub string by stuff

and what statement below do as sub string ,type.value and XML path

SELECT DISTINCT
[InputID],PART_ID,[Vendor ID],Manufacturer,[Digi-Key Part No.] ,[Mfr Part No.],[Description],Category,Family ,Obsolete ,[Non-Stock]
, [Part_Status],partNumber,CompanyName,DKFeatureName2,[Variant Number],IsUnit,
SUBSTRING((

SELECT isnull(StarFormat,'') + Value+ isnull(endFormat,'')
FROM #FinalTable
WHERE ([InputID] = Results.[InputID] and DkFeatureId = Results.DkFeatureId)
FOR XML PATH(''),TYPE).value('.', 'NVARCHAR(MAX)')
,1,5000) AS Value
FROM #FinalTable Results
where StatusId=3

Answer 1

Hi @ahmed salah

Could you please describe the issues and your expected result as this case: https://stackoverflow.com/questions/10581772/how-to-split-a-comma-separated-value-to-columns , https://stackoverflow.com/questions/5493510/turning-a-comma-separated-string-into-individual-rows?
Could you please show your current table, and your expected table?

BR,
Mia
If the reply is helped, please do “Accept Answer” .

Answer 2

Hi @ahmed salah ,

Any update?
Is the issue solved?
And if not could you please show your expected table and support us your sample data?

BR,
Mia
If the reply is helped,please do "Accept Answer".--Mia

Answer 3

Hi @ahmed salah ,

Any update?
Is the issue solved?
And if not could you please show your expected table and support us your sample data?

BR,
Mia
If the reply is helped,please do "Accept Answer".--Mia

Answer 4

Hi @ahmed salah ,

Any update?
Is the issue solved?
And if not could you please show your expected table and support us your sample data?

BR,
Mia
If the reply is helped,please do "Accept Answer".--Mia