[dba-VB] First little applet

Andy Lacey andy at minstersystems.co.uk
Wed Nov 18 05:23:43 CST 2009


Congratulations John. Hope father and little applet are both doing well.

Andy


--------- Original Message --------
From: "Discussion concerning Visual Basic and related programming issues."
<dba-vb at databaseadvisors.com>
To: "Discussion concerning Visual Basic and related programming issues."
<dba-vb at databaseadvisors.com>
Subject: Re: [dba-VB] First little applet
Date: 18/11/09 08:55


Congrats to you John,

I suspect once you get a few more utils in your library, you will be flying
from here on.

good for you,

Mark



2009/11/17 jwcolby <jwcolby at colbyconsulting.com>

> Today I wrote my first C# applet. I have to import CSV files coming back
> from a processing house
> into SQL Server. These files had errors in one or more lines in the files.
> Given that there are
> tens of millions of lines in each file it isn't possible to just poke
> around and find the errors.
>
> So I wrote an applet that opens the CSV file, reads the header line and
> counts the " and ,
> characters. Then line by line the applet reads the rest of the lines,
> comparing the counts to that
> header line counts.
>
> This found lines in the file to be imported where " characters had been
> dropped, which was causing
> the import wizard to error out at that point.
>
> So read, compare counts, write good lines to output file, write bad lines
> to an error file.
>
> Simple stuff really but it is my first real work done in C#.
>
> The speed of this kind of thing is pretty darned good too I thought. I was
> getting about 300K lines
> / second read / written. One file had 20.6 million lines, the other had 49
> million lines.
>
> In the past I would have done this in VBA / Access. Of course it took me a
> tad longer to write in
> C# than it would have in VBA.
>
> --
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the dba-VB mailing list