Best way to remove sections of text from a file Post: 302238901

Sponsored Content

Top Forums Shell Programming and Scripting Best way to remove sections of text from a file Post 302238901 by cals64 on Monday 22nd of September 2008 10:17:15 AM

09-22-2008

Registered User

I would have added that the text is not the same for each line, each notice contains 26 line not all are the same. For example:

Code:

                         WE HAVE TRANSFERRED FUNDS FROM YOUR OVERDRAFT PROTECTION
                         SOURCE(S) AS SHOWN BELOW TO PAY THE FOLLOWING TRANSACTION(S):
                         PLEASE RECORD THE TOTAL TRANSFER AMOUNT AS A DEPOSIT IN YOUR
                         DRAFT REGISTER.



    12345-01 JOHN R DOE                     TRAN DATE:09/19/08 EFF DATE:09/19/08 BR:   1

                                         OVERDRAFT TRANSFER TRANSACTION  DRAFT(S) PAID
                                         TYPE  ACCOUNT    AMOUNT    FEE  NUMBER   AMOUNT

                                         S    12345-00    393.28    .00       0   484.00

                                         TOTALS:       393.28    .00







       JOHN R DOE
       123 ANY ST
       ANYWHERE         TX 12345-1234







                         WE HAVE TRANSFERRED FUNDS FROM YOUR OVERDRAFT PROTECTION
                         SOURCE(S) AS SHOWN BELOW TO PAY THE FOLLOWING TRANSACTION(S):
                         PLEASE RECORD THE TOTAL TRANSFER AMOUNT AS A DEPOSIT IN YOUR
                         DRAFT REGISTER.



    12345-01 JOHN R DOE                     TRAN DATE:09/19/08 EFF DATE:09/19/08 BR:   1

                                         OVERDRAFT TRANSFER TRANSACTION  DRAFT(S) PAID
                                         TYPE  ACCOUNT    AMOUNT    FEE  NUMBER   AMOUNT

                                         S    12345-00    393.28    .00       0   484.00

                                         TOTALS:        17.56    .00







       JOHN R DOE
       123 ANY ST
       ANYWHERE         TX 12345-1234







                         WE HAVE TRANSFERRED FUNDS FROM YOUR OVERDRAFT PROTECTION
                         SOURCE(S) AS SHOWN BELOW TO PAY THE FOLLOWING TRANSACTION(S):
                         PLEASE RECORD THE TOTAL TRANSFER AMOUNT AS A DEPOSIT IN YOUR
                         DRAFT REGISTER.



    12345-01 JOHN R DOE                     TRAN DATE:09/19/08 EFF DATE:09/19/08 BR:   1

                                         OVERDRAFT TRANSFER TRANSACTION  DRAFT(S) PAID
                                         TYPE  ACCOUNT    AMOUNT    FEE  NUMBER   AMOUNT

                                         S    12345-00    393.28    .00       0   484.00

                                         TOTALS:        60.54    .00







       JOHN R DOE
       123 ANY ST
       ANYWHERE         TX 12345-1234







                         WE HAVE TRANSFERRED FUNDS FROM YOUR OVERDRAFT PROTECTION
                         SOURCE(S) AS SHOWN BELOW TO PAY THE FOLLOWING TRANSACTION(S):
                         PLEASE RECORD THE TOTAL TRANSFER AMOUNT AS A DEPOSIT IN YOUR
                         DRAFT REGISTER.



    12345-01 JOHN R DOE                     TRAN DATE:09/19/08 EFF DATE:09/19/08 BR:   1

                                         OVERDRAFT TRANSFER TRANSACTION  DRAFT(S) PAID
                                         TYPE  ACCOUNT    AMOUNT    FEE  NUMBER   AMOUNT

                                         L    12345-20    393.28    .00       0   484.00

                                         TOTALS:        32.24    .00







       JOHN R DOE
       123 ANY ST
       ANYWHERE         TX 12345-1234
                                        






                         WE HAVE TRANSFERRED FUNDS FROM YOUR OVERDRAFT PROTECTION
                         SOURCE(S) AS SHOWN BELOW TO PAY THE FOLLOWING TRANSACTION(S):
                         PLEASE RECORD THE TOTAL TRANSFER AMOUNT AS A DEPOSIT IN YOUR
                         DRAFT REGISTER.



    12345-01 JOHN R DOE                     TRAN DATE:09/19/08 EFF DATE:09/19/08 BR:   1

                                         OVERDRAFT TRANSFER TRANSACTION  DRAFT(S) PAID
                                         TYPE  ACCOUNT    AMOUNT    FEE  NUMBER   AMOUNT

                                         S    12345-00    393.28    .00       0   484.00

                                         TOTALS:        49.58    .00







       JOHN R DOE
       123 ANY ST
       ANYWHERE         TX 12345-1234







                         WE HAVE TRANSFERRED FUNDS FROM YOUR OVERDRAFT PROTECTION
                         SOURCE(S) AS SHOWN BELOW TO PAY THE FOLLOWING TRANSACTION(S):
                         PLEASE RECORD THE TOTAL TRANSFER AMOUNT AS A DEPOSIT IN YOUR
                         DRAFT REGISTER.



    12345-01 JOHN R DOE                     TRAN DATE:09/19/08 EFF DATE:09/19/08 BR:   1

                                         OVERDRAFT TRANSFER TRANSACTION  DRAFT(S) PAID
                                         TYPE  ACCOUNT    AMOUNT    FEE  NUMBER   AMOUNT

                                         L    12345-01    393.28    .00       0   484.00

                                         TOTALS:       454.34    .00







       JOHN R DOE
       123 ANY ST
       ANYWHERE         TX 12345-1234

I want to keep the notices with "L" and discard the ones with "S". How this helps. Thank you!

cals64

View Public Profile for cals64

Find all posts by cals64

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

extract multiple sections of a file

I have a file that I need to parse multiple sections from the file. The file contains multiple lines that start with ST (Abunch of data) Then the file contains multiple lines that start with SE (Abunch of data) SE*30*0001 ...

2. Shell Programming and Scripting

extract multiple sections of file

3. Shell Programming and Scripting

Parsing file, yaml file? Extracting specific sections

Here is a data file, which I believe is in YAML. I am trying to retrieve just the 'addon_domains" section, which doesnt seem to be as easy as I had originally thought. Any help on this would be greatly appreciated!! I have been trying to do this in awk and mostly bash scripting instead of perl...

4. Shell Programming and Scripting

Remove sections of a xml file with sed

I've been trying to remove some lines of a xml file that looks like this: <parent> <child>name1</child> <lots_of_other tags></lots_of_other_tags> </parent> <parent> <child>name2</child> <lots_of_other tags></lots_of_other_tags> </parent> <parent> <child>name3</child> ...

5. Programming

extract different sections of a file

Hi All, I have a file with the data 10;20;30;40;50;60;70;80;123;145;156;345. the output i want is the first fourth sixth elements and everything from there on. How do i achieve this.

6. Shell Programming and Scripting

awk removing sections of a file

I have a file that looks liek this (see below). can somebody provide me with and awk or sed command that can take a piece of the file starting from the time to the blank line and put in into another file. For example: How would I get the data from 10:56:11 to the blank line. Two things: ...

7. Shell Programming and Scripting

Omitting sections of file that contain word

I have a configuration file that contains hundreds of these chunks. Each "chunk" is the section that begins with "define service {" and ends with "}". define service { check_command check_proc!java hostgroup_name service_description ...

8. Shell Programming and Scripting

How to remove sections of a filename?

Hello, I need some help with renaming some files by removing a certain portion of the filename. The current file name is: ABC_2013186197_20130708_203556.95336 I need to remove the 5 digits after the first "_". The new file name should be: ABC_197_20130708_203556.95336 I'm not quite...

9. Shell Programming and Scripting

Remove sections based on duplicate first line

Hi, I have a file with many sections in it. Each section is separated by a blank line. The first line of each section would determine if the section is duplicate or not. if the section is duplicate then remove the entire section from the file. below is the example of input and output....

10. Shell Programming and Scripting

How to remove the text between all curly brackets from text file?

Hello experts, I have a text file with lot of curly brackets (both opening { & closing } ). I need to delete them alongwith the text between opening & closing brackets' pair. For ex: Input:- 59. Rh1 Qe4 {(Qf5-e4 Qd8-g8+ Kg6-f5 Qg8-h7+ Kf5-e5 Qh7-e7+ Ke5-f5 Qe7-d7+ Qe4-e6 Qd7-h7+ Qe6-g6...