static void Main(string[] args) { Encoding inputEncoding = Encoding.UTF8; Encoding outputEncoding = Encoding.UTF8; Encoding errorEncoding = Encoding.UTF8; CsvNormalizer normalizer = new CsvNormalizer(); Console.OutputEncoding = outputEncoding; using (StreamReader inStream = new StreamReader(Console.OpenStandardInput(), inputEncoding)) //using( StreamReader inStream = new StreamReader("./Instructions/DB-sample-with-broken-utf8.csv", inputEncoding) ) using (StreamWriter outStream = new StreamWriter(Console.OpenStandardOutput(), outputEncoding)) //using (StreamWriter outStream = new StreamWriter("./Instructions/DB-sample-with-broken-utf8.out.csv", false, outputEncoding) ) using (StreamWriter errStream = new StreamWriter(Console.OpenStandardError(), errorEncoding)) //using (StreamWriter outStream = new StreamWriter("./Instructions/DB-sample-with-broken-utf8.err.csv", false, outputEncoding) ) { //Columns: Timestamp,Address,ZIP,FullName,FooDuration,BarDuration,TotalDuration,Notes List <CsvNormalizer.DataType> columnTypes = new List <CsvNormalizer.DataType>() { CsvNormalizer.DataType.Timestamp, CsvNormalizer.DataType.UnmodifiedString, CsvNormalizer.DataType.ZipCode, CsvNormalizer.DataType.FullName, CsvNormalizer.DataType.Duration, CsvNormalizer.DataType.Duration, CsvNormalizer.DataType.TotalDuration, CsvNormalizer.DataType.UnmodifiedString }; try { normalizer.ColumnTypes = columnTypes; normalizer.Delimiter = ","; normalizer.TimestampOffset = 3; normalizer.TimestampOutputFormat = "s"; normalizer.NormalizeCsv(inStream, outStream, outStream); } catch (Exception e) { Console.WriteLine(e.Message); } } }
public CsvNormalizerTests() { normalizer = new CsvNormalizer(logger.Object); }