Using Script Destination Object To Create And Write To New Text File

Is there a better way to do this?

We've all seen this, where it uses an individual .write statement for each column.





Code Snippet

Public Overrides Sub AWCCogent_ProcessInputRow(ByVal Row As AWCCogentBuffer)


With textWriter

Dim item As Object

If Not Row.AddressID_IsNull Then
.Write(Row.AddressID)
End If
.Write(columnDelimiter)
If Not Row.City_IsNull Then
.Write(Row.City)
End If

.WriteLine()


End With

End Sub


But hard coding this seems not the smartest way. Especially since in my text file, there needs to be close to 100 columns. This could be a nightmare to update down the road. But I can't seem to find the object collection to loop through, like row.items which would seem to be logical.

There's gotta be a better way, right Microsoft?