FileHelpers Support

Library Support :: RE: Import csv without knowing layout

Marcos — Fri, 06 Nov 2009 17:44:24 GMT

Author: Marcos
Posted: Fri Nov 06, 2009 17:44 (GMT 0)

Hi there

In fact u can do that but for such a generic work you can maybe try with this library

A Fast CSV ReaderbBy Sebastien Lorion

http://www.codeproject.com/KB/database/CsvReader.aspx

Is to read generic CSV files, the work of FileHelpers is to strong type the files but we never finish the support for unkown files

I hope this helps

Best Regards
_________________
Happy Coding
Marcos ( www.devoo.net )
If you like the library support us with some books or monetary donations
Vote FileHelpers in Codeproject or Bookmark us in Delicious or here, Thanks !

Library Support :: RE: Import csv without knowing layout

jcallas — Fri, 06 Nov 2009 16:36:00 GMT

Author: jcallas
Posted: Fri Nov 06, 2009 16:36 (GMT 0)

Seems I found the answer in another post. The post is titled "List type fields?" and I was completely unaware that I can put in arrays in my row definition. Very cool.

Library Support :: Import csv without knowing layout

jcallas — Fri, 06 Nov 2009 16:16:54 GMT

Author: jcallas
Subject: Import csv without knowing layout
Posted: Fri Nov 06, 2009 16:16 (GMT 0)

I need to create a tool that can be used to import csv files with varying numbers of columns, manipulate columns based on column number, and then output the results. Can I use the runtime logic to do this? I have (in other projects) dynamically created type classes for output purposes, but in this case I will have no idea how many columns I will have beforehand. I am even ok with getting back a collection of rows with column names like Colum1, Column2, etc.

Thanks.

Jason

Library Support :: RE: How to read delimited rec with quotes INSIDE (quoted) field?

frank vdb — Wed, 21 Oct 2009 13:12:35 GMT

Author: frank vdb
Posted: Wed Oct 21, 2009 13:12 (GMT 0)

I had similar problems. I used this approach that works for me:

Code:

static void engine_BeforeReadRecord(EngineBase engine, BeforeReadRecordEventArgs e)
{
string newString = System.Text.RegularExpressions.Regex.Replace(e.RecordLine, @"([^\^,\r\n])""([^$,\r\n])", @"$1$2");
if (newString != e.RecordLine)
{
e.RecordLine = newString;
}

}

Frank

Developers Discussions :: RE: Class Property Attributes vs Field Attributes

Marcos — Mon, 19 Oct 2009 02:56:28 GMT

Author: Marcos
Posted: Mon Oct 19, 2009 2:56 (GMT 0)

Hi there

In fact u only need to define a public property and define a private field with the attribute, so u got the result u want, maybe not the best shortcut but I do it all the time at work

Best Regards
_________________
Happy Coding
Marcos ( www.devoo.net )
If you like the library support us with some books or monetary donations
Vote FileHelpers in Codeproject or Bookmark us in Delicious or here, Thanks !

Developers Discussions :: RE: Class Property Attributes vs Field Attributes

Matt Campbell — Fri, 16 Oct 2009 19:29:00 GMT

Author: Matt Campbell
Posted: Fri Oct 16, 2009 19:29 (GMT 0)

Unfortunately, not yet, but it's on our radar. Look for this to be supported in an upcoming version.

Developers Discussions :: Class Property Attributes vs Field Attributes

yacht29 — Fri, 16 Oct 2009 12:40:16 GMT

Author: yacht29
Subject: Class Property Attributes vs Field Attributes
Posted: Fri Oct 16, 2009 12:40 (GMT 0)

In my application I have to define class properties, no public fields. Are there any property attributes similar to fields attributes(e.g. FieldFixedLength)?

Developers Discussions :: CSV - no header row

LHjbh — Wed, 14 Oct 2009 13:18:19 GMT

Author: LHjbh
Subject: CSV - no header row
Posted: Wed Oct 14, 2009 13:18 (GMT 0)

Hello,
I found FileHelpers yesterday and this save my life, because a Export to CSV is so simply.
But I have problem, in my CSV-file is no header row. The first row is the first data-row, but I need the header row with name of the columns.

Code:

CsvOptions options = new CsvOptions("CSV", ';', FileName);
options.HeaderLines = 1;
options.HeaderDelimiter = ';';
CommonEngine.DataTableToCsv(set.Tables[0], FileName, options);

What is wrong at my code?
Thx for your help!