Extracting specific information

  • Thread starter Thread starter Tat
  • Start date Start date
T

Tat

Here is an actual sample of an exported file that I am
dealing with from EasyPay Payroll:

Code : Name : Smith, Jacque line
Type/F

LIFE 7.78 RRSP RgBen 385.31 WSIB 124.19
RRSP% 192.65 LTD RgDed 104.94 LIFE 5.18
AD&D 2.16 EHC RgDed 27.22 DENTAL 29.28
VST-AD 10870.65VST-PE SpPay 6942.6 OBP 995.21
STATEI 795.3 OTHER SpPay 300
------- -------- ----------- -------- ---

Code : Name : Jones, Septemb er Type/F

LIFE 7.78 RRSP RgBen 373.12 WSIB 109.34
RRSP% 186.56 LTD RgDed 83.94 LIFE 5.18
AD&D 2.16 EHC RgDed 8.68 DENTAL 12.62
VST-AD 302.88 OBP 302.89
STATEI 623.42 OTHER SpPay 240
------- -------- ----------- -------- ---



Note the employee name ends up broken in 3 columns.
You will also notice that the same information for the
above two employees is not located in the same columns
because of the way Easypay sets their information up.

I would like the following info extracted from each
employee so it looks like the following:

Employee Name Vst-AD Vst-PE OBP
Smith, Jacqueline 10870.65 6942.60 995.21
Jones, September 302.88 302.89

What I would like to do is:
1)If column = "Name" print the employees names in list.
(It would have to be concatenated because the name may or
may not span 2 to 3 columns).
2)If any of the columns holding data for each employee
="VST-AD", then print the amount from the adjacent column.
Do this for VST-PE and OBP for each employee.

Any help with this would be appreciated.
 
The original response did not work because I assume I
didn't give enough information and as a result there were
not more responses so I thought I give more details.
 
Back
Top