One day while browsing the Code Project, I found an excellent article by Tony Selke 'Wrapper Class for Parsing Fixed-Width or Delimited Text Files'. I decided that I would port the code to C# because that is my language of choice. While doing this, I also added a couple of features:
- I added the ability to put the schema for the text file in an XML file.
- I added the ability to parse the text file directly to a
This is my first article submitted to the Code Project, so be gentle.
What can it do?
The library can import delimited or fixed width files while the developer decides what to do with each record by subscribing to the
RecordFound event. The library can import delimited or fixed width files directly into a
How does it work?
The developer sets up a schema either with code or in an XML schema file. This determines the data types that will be used in the
DataTable. Based on the schema, the text values are parsed and converted to the respective data types and either put in a
DataTable or simply passed to the calling object as an event.
Using the code
The first thing to do is, add a reference to the library. Then add the
using statement at the top of your source file.
Create an instance of the
TextFieldParser tfp = new TextFieldParser(filePath);
If you will be using an XML schema file, use the constructor that has the '
TextFieldParser tfp = new TextFieldParser(filePath, schemaPath);
If using an XML schema file, the following is an example of how the XML schema file would look:
<TABLE Name="TEST" FileFormat="Delimited" ID="Table1">
<FIELD Name="LineNumber" DataType="Int32" />
<FIELD Name="Quoted String" DataType="String" Quoted="true" />
<FIELD Name="Unquoted String" DataType="String" Quoted="false" />
<FIELD Name="Double" DataType="Double" />
<FIELD Name="Boolean" DataType="Boolean" />
<FIELD Name="Decimal" DataType="Decimal" />
<FIELD Name="DateTime" DataType="DateTime" />
<FIELD Name="Int16" DataType="Int16" />
I have included with the source code a complete description of the schema file attributes. Here is an example of the same thing, but done in code.
TextFieldCollection fields = new TextFieldCollection();
fields.Add(new TextField("Line Number", TypeCode.Int32));
fields.Add(new TextField("Quoted String", TypeCode.String, true));
fields.Add(new TextField("Unquoted String", TypeCode.String, false));
fields.Add(new TextField("Double", TypeCode.Double));
fields.Add(new TextField("Boolean", TypeCode.Boolean));
fields.Add(new TextField("Decimal", TypeCode.Decimal));
fields.Add(new TextField("DateTime", TypeCode.DateTime));
fields.Add(new TextField("Int16", TypeCode.Int16));
tfp.TextFields = fields;
Now you can either subscribe to the
RecordFound event if you want to do something custom with the records...
tfp.RecordFound += new RecordFoundHandler(tfp_RecordFound);
private void tfp_RecordFound(ref int CurrentLineNumber,
or you can call
ParseToDataTable to get the results in a
DataTable dt = tfp.ParseToDataTable();
Note: Even when calling
RecordFound event is still fired.
You can also subscribe to the
RecordFailed event to get notification of when a record fails to parse. In the event handler, you can decide if you can continue or not.
tfp.RecordFailed += new RecordFailedHandler(tfp_RecordFailed);
private void tfp_RecordFailed(ref int CurrentLineNumber,
string LineText, string ErrorMessage, ref bool Continue)
MessageBox.Show("Error: " + ErrorMessage + Environment.NewLine +
"Line: " + LineText);
That's it. I look forward to comments, suggestions from you all.