You need to have something that defines the column with typeof(String) Here's a C# action I wrote that'll handle CSVs with custom delimiters.
Inputs:
Delimiter - Text
Target - Text
headers - Flag
Outputs:
Collection - Collection
var file = Target;
var parser = new TextFieldParser(file);
var dt = new DataTable();
parser.SetDelimiters(Delimiter);
string temp = "";
int count=0;
while(!parser.EndOfData)
{
if(count==0)
{
string[] columns = parser.ReadFields();
if(headers)
{
foreach(string title in columns)
{
string colName = title;
int num=0;
while(dt.Columns.Contains(colName))
{
colName = string.Format("{0}_{1}",title,++num);
}
dt.Columns.Add(colName, typeof(String));
temp+=title;
}
}
else
{
int fields = columns.Length;
int colCount=1;
while(colCount<=fields)
{
string colName="F"+colCount.ToString();
dt.Columns.Add(colName, typeof(String));
colCount++;
}
var dataTableRow = dt.NewRow();
dt.Rows.Add(columns);
}
}
else
{
var dataTableRow = dt.NewRow();
dataTableRow.ItemArray = parser.ReadFields();
dt.Rows.Add(dataTableRow);
}
count++;
}
Collection = dt;
row = temp;
