• Matthew,

    Here's an example of what you could do. In the example I don't pivot the data as I just want to split the string and have multiple rows. You should be able to figure out how to Pivot it if that is your need:

    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

    Dim RowId As String = Row.RowID

    Dim DelimitedList As String = Row.DelimitedList

    Dim delimiter As String = ","

    If Not String.IsNullOrEmpty(RowId.Trim) Then

    If Not (String.IsNullOrEmpty(DelimitedList)) Then

    Dim DelimitedListArray() As String = DelimitedList.Split(New String() {delimiter}, StringSplitOptions.RemoveEmptyEntries)

    For Each item As String In DelimitedListArray

    With Output0Buffer

    .AddRow()

    .RowId = RowId

    .Item = item.Replace(ControlChars.Cr, "").Replace(ControlChars.Lf, "").Replace(ControlChars.Tab, "").Trim()

    End With

    Next

    End If

    End If

    End Sub