Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Best way to remove sections of text from a file
Top Forums Shell Programming and Scripting Best way to remove sections of text from a file Post 302238908 by joeyg on Monday 22nd of September 2008 11:16:02 AM
Old 09-22-2008
Tools convoluted approach, but appears to work
Determine the records (account #'s) you want to keep
Code:
> cut -c42-54 file1 | grep "^[SL]    [0-9]\{5\}-[0-9]\{2\}" | grep "^L" >L_FILES
> cat L_FILES
L    12345-20
L    12345-01

Now, a strange set of commands piped together
Code:
> cat file1 | sed "s/                         WE HAVE/~                         WE HAVE/" | tr "\n" "|" | tr "~" "\n" | egrep -f L_FILES | tr "\n" "~" | tr "|" "\n" | tr -d "~"

And the output looks right
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

                                         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

                                         L    12345-01    393.28    .00       0   484.00

                                         TOTALS:       454.34    .00







       JOHN R DOE
       123 ANY ST
       ANYWHERE         TX 12345-1234

Although gotta believe there is an awk command to verify the account #. Will need to think about that, or perhaps someone else here better at awk could help.
 

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 ... (1 Reply)
Discussion started by: rgentis
1 Replies

2. Shell Programming and Scripting

extract multiple sections of 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 ST*810*0002 I need all of the lines between and including these.... (6 Replies)
Discussion started by: rgentis
6 Replies

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... (3 Replies)
Discussion started by: Rhije
3 Replies

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 Replies)
Discussion started by: viniciusandre
5 Replies

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. (1 Reply)
Discussion started by: raghu_shekar
1 Replies

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: ... (5 Replies)
Discussion started by: BeefStu
5 Replies

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 ... (5 Replies)
Discussion started by: SkySmart
5 Replies

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... (5 Replies)
Discussion started by: bbbngowc
5 Replies

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.... (5 Replies)
Discussion started by: ahmedwaseem2000
5 Replies

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... (6 Replies)
Discussion started by: prvnrk
6 Replies

LEARN ABOUT MINIX

grep

GREP(1) 						      General Commands Manual							   GREP(1)

NAME

       grep - search a file for lines containing a given pattern

SYNOPSIS

       grep [-elnsv] pattern [file] ...

OPTIONS

       -e     -e pattern is the same as pattern

       -c     Print a count of lines matched

       -i     Ignore case

       -l     Print file names, no lines

       -n     Print line numbers

       -s     Status only, no printed output

       -v     Select lines that do not match

EXAMPLES

       grep mouse file	   # Find lines in file containing mouse

       grep [0-9] file	   # Print lines containing a digit

DESCRIPTION

       Grep  searches  one  or	more  files (by default, stdin) and selects out all the lines that match the pattern.  All the regular expressions
       accepted by ed and mined are allowed.  In addition, + can be used instead of * to mean 1 or more occurrences, ? can be used to mean 0 or  1
       occurrences,  and  |  can  be used between two regular expressions to mean either one of them.  Parentheses can be used for grouping.  If a
       match is found, exit status 0 is returned.  If no match is found, exit status 1 is returned.  If an error is detected,  exit  status  2	is
       returned.

SEE ALSO

       cgrep(1), fgrep(1), sed(1), awk(9).

																	   GREP(1)
All times are GMT -4. The time now is 01:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy