I have a csv file composed of n records each of which consists of six numbers, I need to filter this file to generate a new file that contains only the records that satisfy a specific condition set through a template made in excel .
Each line of the file to be filtered must comply with a condition that is :
the total of numbers present in each group as set in row 44 (I44, L44, O 44, R44 .... BE44) must satisfy a minimum and a maximum of presence as well as specified in BB7 / BC7 for the specific record analyzed to be validated.
For example, the record reported as test (3 30 47 67 68 89) highlights a string of attendances equal to 0 0 0 1 0 4 3 3 3 3 1 0 0 (groups in which there are no numbers are not considered) which to the conditional string of line 44 it confirms the presence of a min of 4 and a max of 4 conditions met (see the 4 green stripes placed in correspondence with the occurrences that represent compliance with the condition).
While for example the record 3 8 10 47 48 84 will be discarded and therefore not present in the Outputfile.csv file as it satisfies only 3 conditions instead of the minimum 4 provided.
The file provided as an example 'ToPurgeFile.csv' consists of 6545 records and theoretically should be reduced by more than 50% with the excel template attached.
as I can't write the code, my knowledge is too poor, I ask if someone can write it for me
thanks in advance