0

This is a sample from a payroll file I have to work with, it lists employee number, different types of earnings, & check date. The goal is to get a subtotal per employee that lists the employee's total wages and other earnings. I can't get my head around how to do this, can someone offer some suggestions? Some employees may have only one line, other employees may have lines with no regular wage types, only deductions/earnings (bonuses, insurance, etc...)

240 TN  DP  800.00  1696.65 .00 .00 .00 .00 65  46.20   11/10/11
240 TN  DP  800.00  1696.65 .00 .00 .00 .00 66  124.83  11/10/11
240 TN  DP  800.00  1696.65 .00 .00 .00 .00 72  5.27    11/10/11
240 TN  DP  800.00  1696.65 .00 .00 .00 .00 ZC  1933.75 11/10/11
240 TN  DP  800.00  1643.55 .00 .00 .00 .00 65  46.20   11/25/11
240 TN  DP  800.00  1643.55 .00 .00 .00 .00 66  122.18  11/25/11
240 TN  DP  800.00  1643.55 .00 .00 .00 .00 72  5.27    11/25/11
240 TN  DP  800.00  1643.55 .00 .00 .00 .00 ZC  1893.87 11/25/11
240 TN  DP  .00 .00 .00 .00 400.00  .00 66  20.00   12/09/11
240 TN  DP  800.00  1595.25 .00 80.00   .00 .00 65  46.20   12/09/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 65  .00 07/08/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 67  .00 07/08/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 69  .00 07/08/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 72  .00 07/08/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 74  .00 07/08/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 ZC  1299.03 07/08/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 65  181.85  07/22/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 67  12.46   07/22/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 69  .00 07/22/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 72  22.15   07/22/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 74  .00 07/22/11
242 TN  DP  1538.46 .00 .00 .00 .00 .00 ZC  1124.70 07/22/11
2
Contributors
1
Reply
2
Views
4 Years
Discussion Span
Last Post by nmaillet
0

Put it in a loop, read each line and split each line up with the string.Split() method or the Regex class. Post some code and ask some specific questions, otherwise you probably won't get much help here.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.