.NET C# CSV row consolidation

*** IMPORTANT *** 1) DO NOT BID IF YOU CANNOT START RIGHT AWAY 2) DO NOT BID UNLESS YOU FULLY UNDERSTAND THE PROJECT DESCRIPTION 3) DO NOT BID UNLESS YOU HAD A CLOSE LOOK AT THE ATTACHED FILE 4) AND FINALLY: ONLY PLACE A BID IF YOU ARE ABSOLUTELY SURE YOU CAN DELIVER WITHIN TWO DAYS I am sorry for being so blunt but I do not want to waste your time and naturally I also do not want my time to be wasted. The objective is to create a .NET 4.x C# application that will load a CSV (like the one attached) and will consolidate the rows based on certain criteria. The CSV consists of thousands of rows of dial code ranges. Each row depicts one range. The dial code consists of an aggregate of column[7] (NIR) + column[8] (SERIE) + the range defined by columns 9+10. As are some examples: Row NIR Serie Range Resulting dial codes 2 449 246 0 - 9999 4492460000 - 4492469999 5 449 891 1000-8999 4498911000 - 4498918999 11 449 891 0 - 999 4498910000 - 4498910999 The length of the dial codes is always 10 digits. That is why in the examples above the dial codes where padded with 0 to the left. So a "0" in this case is a "0000" if the length of NIR+Serie == 6 and the "999" is actually "0999" if the length of NIR+Serie == 6 (as in the example above). There are 5 indicators that identify if a range can be consolidated: 1) NIR is equal 2) SERIE is equal 3) Operator (RAZON SOCIAL) is equal 4) Type (TIPO DE RED) is equal 5) Sub-Type (MODALIDAD) is equal * * The application should allow for the sub-type (MODLIDAD) to be ignored by means of a checkbox. The application should check all rows for potential consolidation and in case the indicators mentioned above are equal across several rows then they should be reduced to just one row with a larger range (max 0-9999). For example (if the subtype is ignored): Rows 5 through 7 have the same NIR, SERIE, TIPO DE RED and RAZON SOCIAL. So instead of 3 rows with ranges of 1000-8999, 9000-9999 and 0-999 the application should just write one row with a range of 0-9999. Very important: the NIR and SERIE columns will NOT be sorted in the source file so unless you pre-process the application cannot just check row by row if the columns are equal to determine potential for consolidation! The source file will be comma separated with the individual fields enclosed by ". Attached are two files: [login to view URL] (this is the one the examples in this description are taken from) [login to view URL] (this is the file that the application would need to consolidate) And please make absolutely sure that you will start your bid with "Yes, I have!" to demonstrate that you have fully read - and understood - the requirements. Otherwise your bid will be ignored.