[dba-VB] First little applet

ROTFL.  Father is so proud of little applet.

;)

John W. Colby
www.ColbyConsulting.com


Andy Lacey wrote:
> 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
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
>