I would have sworn one of the default utility object had a basic action for this, but I'm not finding it. Below is the version I wrote to accept custom delimiters using c#.
Inputs:
Collection - Collection
Delimiter - Text
Target - Text
StringBuilder sb = new StringBuilder();
string[] columnNames = Collection.Columns.Cast().Select(column => column.ColumnName).ToArray();
sb.AppendLine(string.Join(Delimiter, columnNames));
foreach (DataRow row in Collection.Rows)
{
string[] fields = row.ItemArray.Select(field => field.ToString()).ToArray();
sb.AppendLine(string.Join(Delimiter, fields));
}
File.WriteAllText(Target, sb.ToString());
