Hello All,
Is there an easy way to extract data from a text file? The text file is actually a dump of a 2 page report with 6 columns and 122 lines. Example is
Report Tile
Type Product 1 Product 2 Product 3 Product 4 Product 5
Budget
Current
MTD
YTD.
Payments
Second Page of Report :
Report Tile
Type Product 6 Product 7 Product 8 Product 9 Grand Total
Budget
Current
MTD
YTD.
Payments
Say we only want to get the amount in :
Current - Product8, Product 9 and grand total.
MTD - Product8, product9 and Grand total
YTD - product8, product9 and Grand Total
Checking the text file, these are in rows 81, 82 and 83.
Thanks!
negixx