Chizl.TextConverter

Load text files into DataTables and has the ability to write to a different file type.

Current Supported File Types

• Fixed Length Columns
• Tab Delimited
• Comma Delimited
• Quote Comma Delimited
• Semicolon Delimited

Supported Column Types:

• Boolean
• Byte[]
• DateTime
• Decimal
• Guid
• Int64
• String
• TimeSpan

A .NET6 Core console Demo included.

Written in

• Visual Studio 2022 Professional on Win11

Supports

• netstandard2.0
• netstandard2.1
• net47
• net48
• net6.0
• net7.0
• net8.0

Dependencies

• None

Example with CSV

   LoadFile loadFile = new(".\\myfile.csv", FileTypes.Comma_Delimited);
   loadFile.ColumnDefinitions = new()
   {
       new ColumnDefinition("Column1", DataTypes.String, 20),
       new ColumnDefinition("Column2", DataTypes.String, 1) { AllowedValues=new List<object>{ "A", "B" } },
       new ColumnDefinition("Column3", DataTypes.DateTime),
       new ColumnDefinition("Column4", DataTypes.Decimal, decimalSize:2),
       new ColumnDefinition("Column5", DataTypes.Boolean),
       new ColumnDefinition("Column6", DataTypes.Int64) { AllowDBNull=true },
       new ColumnDefinition("Column7", DataTypes.TimeSpan, 25),
       new ColumnDefinition("Column8", DataTypes.ByteArray, 35)
   };

   if (loadFile.Validate()) 
   {
       Console.WriteLine("Validation Success!");
       DataTable dt = loadFile.AsDataTable.Copy();
   }
   else
   {
       foreach (AuditLog vl in loadFile.AuditLogs)
       {
           Console.WriteLine($"{vl.MessageType.Name()} {vl.ValidationType.Name()}: {vl.Location} - {vl.Message}");
       }
   }

Example with Fixed Length Columns

    LoadFile loadFile = new(".\\myfile_FixedLengthColumns.txt", FileTypes.Fixed_Length_Columns);
    loadFile.ColumnDefinitions = new()
    {
        new ColumnDefinition("MSACode", DataTypes.Int64, 5),
        new ColumnDefinition("MetroDivCode", DataTypes.Int64, 5),
        new ColumnDefinition("MSAName", DataTypes.String, 50),
        new ColumnDefinition("SOACode", DataTypes.String, 5),
        new ColumnDefinition("LimitType", DataTypes.String, 1){ AllowedValues=new List<object> { "S", "H" } },
        new ColumnDefinition("MedianPrice", DataTypes.Int64, 7),
        new ColumnDefinition("LimitFor1LivUnit", DataTypes.Int64, 7),
        new ColumnDefinition("LimitFor2LivUnits", DataTypes.Int64, 7)
    };

    if (loadFile.Validate()) 
    {
        Console.WriteLine("Validation Success!");
        DataTable dt = loadFile.AsDataTable.Copy();
    }
    else
    {
        foreach (AuditLog vl in loadFile.AuditLogs)
        {
            Console.WriteLine($"{vl.MessageType.Name()} {vl.ValidationType.Name()}: {vl.Location} - {vl.Message}");
        }
    }

Questions and Answers

Q: Why are there only Int64 and not Int16 or Int32?
A: Since this is a conversion tool, it's all temporary storage. Int64 being the largest it covers all Ints or Longs. This was done for String instead of Char, Decimal instead of Double, etc. You can set length and floating-point length as part of ColumnDefinition.

Q: If I just want to dump the information to the screen, what is the best way to format it?
A: The Demo has a method named, DisplayTable(). It dumps all columns and data to the console window. In this demo it also writes the converted data to file. Since all rows and columns are separated and validated in the DataTable this demo will show what special conversions (Byte[] and DBNull data) are handled.
NOTE: DBNull data comes from column where AllowDBNull is set, no matter what DataType the column is.

Example:

Row #  | Column1             | Column2   | Column3                | Column4     | Column5     | Column6    | Column7                     | Column8                               |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1      | test1 text data     | A         | 12/15/1970 5:39:35 AM  | 50.05       | True        | 545151     | 10675199.02:48:05.4775807   | LTEwNjc1MTk5LjAyOjQ4OjA1LjQ3NzU4MDg=  |
2      | test2 data          | B         | 10/10/2000 4:39:35 PM  | 100.56      | False       | 545151     | 10675199.02:48:05.4775807   | LTEwNjc1MTk5LjAyOjQ4OjA1LjQ3NzU4MDg=  |
3      | test3 text          | B         | 11/11/2020 3:39:35 AM  | 1000.5      | True        | 545151     | 10675199.02:48:05.4775807   | LTEwNjc1MTk5LjAyOjQ4OjA1LjQ3NzU4MDg=  |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Links

Home Page
License