What Sultan provided is a pretty long way about getting this data out in a transformation. But like most things, there are multiple ways to do one thing. If you're in a transformation you can do something like so:
<script runat="server">
using System.Linq;
public string GetSplitValues()
{
List<string> values = Eval<string>("ColumnName").Split("|").ToList();
string returnValue = "";
foreach (string s in values)
{
returnValue += "<li>" + s + "</li>";
}
return returnValue;
}
</script>
<ul>
<%# GetSplitValues() %>
</ul>
Your output would look like the following:
- List item 1
- List item 2
- List item 3
Now if you have actual values or IDs in the list, you'd need to perform a lookup inside that foreach
loop. This would then be better as a custom transformation method.