>Hi Cetin,
>
>>.Net doesn't need to read it line by line using a filestream. It could use a CSV provider
>
>I'm quite sure you have way more .NET knowledge than me. I'd really like to see if a CSV provider is really faster than using a file stream. Could you show me some sample code?
>
>TIA,
>
>Markus
Yes, I could at my offtime (probably tonight). I actually would like to see the clear definitions of the contest (I tried German site but couldn't understand). ie: What is a duplicate?
Are these duplicates?
Blumen strasse
Blumen strase
Blumen straße
Blumen Strasse
Blumen St.
if not and only full line is defining a duplicate (and somewhere I saw that you had a structure that I couldn't understand where it comes from, for example why email was c(38) and not c(40), c(50) etc - probably contest creator defined the structure) then a single field append from, union or distinct SQL would eliminate duplicates. Anyway A very loose contest as I could see (sound like someone is trying to make others do his homework:).
Cetin