private static DataTable GDFCSVFile2(string csv_file_path)
{
DataTable csv_Data = new DataTable();
try
{
using (TextFieldParser csvReader = new TextFieldParser(csv_file_path))
{
csvReader.SetDelimiters(new string[] { "," });
csvReader.HasFieldsEnclosedInQuotes = true;
string[] colFileds = csvReader.ReadFields();
foreach (string column in colFileds)
{
DataColumn dclm = new DataColumn(column);
dclm.AllowDBNull = false;
csv_Data.Columns.Add(dclm);
}
while (!csvReader.EndOfData)
{
string[] fieldData = csvReader.ReadFields();
fieldData[2] = CLeaning_Operation_DLL.Clean_Operation_Marks(fieldData[2]).ToString();
csv_Data.Rows.Add(fieldData);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(csv_Data);
}
private static DataTable GDFCSVFile1(string csv_file_path)
{
DataTable csv_Data = new DataTable();
try
{
using (TextFieldParser csvReader = new TextFieldParser(csv_file_path))
{
csvReader.SetDelimiters(new string[] { "," });
csvReader.HasFieldsEnclosedInQuotes = true;
string[] colFileds = csvReader.ReadFields();
int Column_Spliter = 0;
foreach (string column in colFileds)
{
if (Column_Spliter == 3) // Columns Split here.
{
char ch = '_';
string[] str = column.Split(ch);
foreach (var item in str)
{
csv_Data.Columns.Add(item);
}
}
else
{
++Column_Spliter;
DataColumn datecolumn = new DataColumn(column);
csv_Data.Columns.Add(datecolumn);
}
}
int k = 0;
ArrayList al = new ArrayList();
string[] Adding_Splited_Row_Data;
string[] FinalizeData;
while (!csvReader.EndOfData)
{
string[] fieldData = csvReader.ReadFields();
foreach (var item in fieldData)
{
if (k == 3)
{
char ch = '_';
Adding_Splited_Row_Data = item.Split(ch);
foreach (var item1 in Adding_Splited_Row_Data)
{
al.Add(CLeaning_Operation_DLL.Clean_Operation(item1));
}
}
else
{
al.Add(CLeaning_Operation_DLL.Clean_Operation(item));
k++;
}
} //Making empty value as null
FinalizeData = (String[])al.ToArray(typeof(string));
csv_Data.Rows.Add(FinalizeData);
al.Clear();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(csv_Data);
}
