Record Conditions Example

You can now filter the records using a lot of conditions to include or exclude each line.

If we have this sample data:

ANTON Antonio Moreno Taquería Antonio Moreno Owner Mataderos 2312 México D.F. Mexico AROUT Around the Horn Thomas Hardy Sales Representative 120 Hanover Sq. London UK BERGS Berglunds snabbköp Christina Berglund Order Administrator Berguvsvägen 8 Luleå Sweden BOTTM Bottom-Dollar Markets Elizabeth Lincoln Accounting Manager 23 Tsawassen Blvd. Tsawassen Canada BSBEV B's Beverages Victoria Ashworth Sales Representative Fauntleroy Circus London UK CACTU Cactus Comidas para llevar Patricio Simpson Sales Agent Cerrito 333 Buenos Aires Argentina COMMI Comércio Mineiro Pedro Afonso Sales Associate Av. dos Lusíadas, 23 Sao Paulo Brazil DRACD Drachenblut Delikatessen Sven Ottlieb Order Administrator Walserweg 21 Aachen Germany EASTC Eastern Connection Ann Devon Sales Agent 35 King George London UK ERNSH Ernst Handel Roland Mendel Sales Manager Kirchgasse 6 Graz Austria FISSA FISSA Fabrica Inter. Salchichas S.A. Diego Roel Accounting Manager C/ Moralzarzal, 86 Madrid Spain FOLIG Folies gourmandes Martine Rancé Assistant Sales Agent 184, chaussée de Tournai Lille France FOLKO Folk och fä HB Maria Larsson Owner Åkergatan 24 Bräcke Sweden FRANK Frankenversand Peter Franken Marketing Manager Berliner Platz 43 München Germany FURIB Furia Bacalhau e Frutos do Mar Lino Rodriguez Sales Manager Jardim das rosas n. 32 Lisboa Portugal GROSR GROSELLA-Restaurante Manuel Pereira Owner 5ª Ave. Los Palos Grandes Caracas Venezuela

We define a record class with an RecordCondition to include all the ones that begin with "F"

[ConditionalRecord(RecordCondition.IncludeIfBegins, "F")] [DelimitedRecord("\t")] public class CustomersTab { public string CustomerID; public string CompanyName; public string ContactName; public string ContactTitle; public string Address; public string City; public string Country; }

If now we run:

FileHelperEngine engine = new FileHelperEngine(typeof(CustomersTab)); CustomersTab[] res = (CustomersTab[]) engine.ReadFile("sample.txt");

And the res array only has this records:

FISSA FISSA Fabrica Inter. Salchichas S.A. Diego Roel Accounting Manager C/ Moralzarzal, 86 Madrid Spain FOLIG Folies gourmandes Martine Rancé Assistant Sales Agent 184, chaussée de Tournai Lille France FOLKO Folk och fä HB Maria Larsson Owner Åkergatan 24 Bräcke Sweden FRANK Frankenversand Peter Franken Marketing Manager Berliner Platz 43 München Germany FURIB Furia Bacalhau e Frutos do Mar Lino Rodriguez Sales Manager Jardim das rosas n. 32 Lisboa Portugal

Remember that you can also do this with the DelimitedFileEngine

DelimitedFileEngine engine = new DelimitedFileEngine(typeof(CustomersTab)); engine.Options.RecordCondition.Condition = RecordCondition.IncludeIfBegins; engine.Options.RecordCondition.Selector = "F"; // The same result CustomersTab[] res = (CustomersTab[]) engine.ReadFile("sample.txt");

Enjoy it !!!

See also

Must Read - Quick Start Guide - Attributes List - F.A.Q. - Examples of Use - Contacts & Credits - Donations

---