Function takes 3 arguments:
String, Field Delimitter, and Row Delimitter and returns a table.
This
SELECT * FROM dbo.udf_Split2('This is,aTest|of the, Split2 function','|',',')
Return this:
ID Value1 Vaue2
1 This is a Test
2 of the Split2 function