Sum line from a txt file

[LZlz15 (LZlz)]

Hello,

I have a txt file that contains several lines and I want to sum up the amount on Column11, if I have the same information on Column4, Column9 and Column10

It should be like in the screenshot

Can anyone help me, please?

Thank you,

[ppr (Peter Preuss)]

Main Building Blocks are:

• parsing CSV Data into a datatable
• Grouping the data and summing up group members Col11 values

For parsing we can do:

• Read CSV / Generate DataTable / enhancing delimeters with the help of Regex

For grouping:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode th…

For summing up:

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints Perf…