Link to home
Start Free TrialLog in
Avatar of Mescronomicon
MescronomiconFlag for Canada

asked on

Removing group of repetitive rows from large excel file.

I have to prepare some files for our friendly neighborhood auditor. These files are generated by our month end procedure in Accpac Plus for DOS.

Two files are generated: an AP (purchases and expenses) file and a OE (sales) file.

Basically what I need to do is take these 24 total text files and open them with Excel and set them up so totals for GL accounts can be viewed easily etc etc.

My problem is that Accpac generates these files with page headers. Each file must have at least 100 pages so when I open them in excel I get the date, page number and column headers every 60 rows or so.

It wouldn't be so bad if these page headers occupied a single line but they span about 8 or 9 lines.

What's the quickest and least painful way I can remove these lines either in Notepad, Word or Excel?

Thanks.
Avatar of gtgloner
gtgloner
Flag of Canada image

Could you post an example of what you see when you have your file in Excel?
Avatar of Mescronomicon

ASKER

Date: Dec 02 2004    3:22pm                           XXXXXXXXXXXXXXXXXXX                                             Page:   1
G/L Transactions

Report information in detail.
Sort G/L transactions by account.

                          Entry                                                                      
 Acct.  Dept. Date          No. Src.Code Reference    Description                              Debit          Credit

10x000        Nov 01 2004     8 AP - MC  CONSEILLER I     3-   3-    1        xxxxx                       xx,xxx.xx
              Nov 01 2004     9 AP - MC  ZENTIL-BRATT     3-   3-    2        xxxxxx                      xx,xxx.xx
              Nov 01 2004    10 AP - MC  GWL REALTY A     3-   3-    3        xxxxxx                        xx,xxx.xx
              Nov 01 2004    11 AP - MC  GROSVENOR CA     3-   3-    4        xxxxx                      xx,xxx.xx
It's aligns however in the actual document.
This is the stuff that repeats every 60 rows or so:


Date: Dec 02 2004    3:22pm                           XXXXXXXXXXXXXXXXXXX                                             Page:   1
G/L Transactions

Report information in detail.
Sort G/L transactions by account.

                          Entry                                                                      
 Acct.  Dept. Date          No. Src.Code Reference    Description                              Debit          Credit


ASKER CERTIFIED SOLUTION
Avatar of R_Rajesh
R_Rajesh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Awesome! Worked like a charm, thanks!