public static void FillRow(Object obj, out string segment, out int i)
{
SplitParts ab = (SplitParts)obj;
segment = ab.result;
i = ab.id;
}
public static IEnumerable clrtvf_Split1(SqlString str, string splitChar)
{
// split str using delimiter in splitChar
//and return it as table valued function
// in format: segment varchar(max), row_number int
string[] m_strlist;
SplitParts[] a;
if (!str.IsNull)
{
m_strlist = str.Value.Split(splitChar.ToCharArray());
int count = m_strlist.GetUpperBound(0);
a = new SplitParts[count + 1];
for (int i = 0; i < m_strlist.GetUpperBound(0) + 1; i++)
{
a[i] = new SplitParts(i, m_strlist[i]);;
}
return(a);
}
else
{
return("");
}
}
