try below code....

declare @Questions varchar(MAX)='1-32|26,42-41|32'

--select * FROM [dbo].split(@Questions)

SELECT LEFT(val, CHARINDEX('-', val)-1) AS QuestionId

, substring(val,(CHARINDEX('-', val)+1),(CHARINDEX('|', substring(val,(CHARINDEX('-', val)+1),len(val)))-1)) AS [IndexNumber]

, SUBSTRING(val, CHARINDEX('|', val)+1, 100) AS Numbers

from FN_SplitData(@Questions,',')