Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Delete records in reverse order

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Delete records in reverse order
# 1  
Old 07-18-2013
Delete records in reverse order
Hi all,
i have dynamic file 'xyz.txt', records always look likes below format ...
Code:
0000021 RET     31-MAR-1984     FAP
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
#################################################
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
################################################
0000021 RET     31-MAR-1984     FAP
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
################################################
0000021 RET     31-MAR-1984     FAP
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
################################################
0000021 DTA     14-JAN-2003     CNV
0000021 RET     31-MAR-1984     FAP
0000021 DTA     26-MAR-2012     DTA

I want to cut or delete (any one would be ok ) records from starting with ##### towords begin (reverse)
e.g. in my case
Code:
0000021 RET     31-MAR-1984     FAP
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
#################################################

above should be my expected result.

same for 2nd
Code:
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
################################################

same for 3rd ..
Code:
0000021 RET     31-MAR-1984     FAP
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
################################################

please help me .
advance Thanks,

Thanks,
Krupa
Last edited by Scott; 07-18-2013 at 11:28 AM.. Reason: Code tags
# 2  
Old 07-18-2013
Try
Code:
awk 'F{print}
    /^#/{F=1}' file

# 3  
Old 07-18-2013
Delete records in reverse order
Hi,

Code:
awk 'F{print} /^#/{F=1}' kkk.txt

i tried but no result...
actually my question is i want to delete lines in reverse order from where '####' will find.

Please help me.

Thanks,
Krupa
Last edited by Scott; 07-18-2013 at 11:29 AM.. Reason: Code tags
# 4  
Old 07-18-2013
Try something like:
Code:
awk '
        !/^#/ {
                A[++c] = $0
        }
        /^#/ {
                print "Record: " ++n
                for ( i = 1; i <= c; i++ )
                {
                        print A[i]
                }
                print $0
                split ( "", A )
                c = 0
        }
' file

This User Gave Thanks to Yoda For This Post:
RavinderSingh13
# 5  
Old 07-18-2013
Try:
Code:
awk 'c==n-1; /^##/{c++}' n=2 file

Code:
0000021 DTA     14-JAN-2003     CNV
0000021 DTA     25-MAR-2012     DTA
0000021 DTA     26-MAR-2012     DTA
################################################

This User Gave Thanks to Scrutinizer For This Post:
RavinderSingh13
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Issues with sorting in reverse order

I have a unix script that outputs a summary file to the mac desktop. The file is called summary.txt I am trying to configure such so that the summary.txt file lists the content contained within such in reverse sort order. I have used sort -r but it does not seem to work. I would be... (8 Replies)
Discussion started by: Braveheart
8 Replies

2. Shell Programming and Scripting

Sorting strings in reverse order

Hello, I have a large database of words and would like them sorted in reverse order i.e. from the end up. An example will make this clear: I have tried to write a program in Perl which basically takes the string from the end and tries to sort from that end but it does not seem... (5 Replies)
Discussion started by: gimley
5 Replies

3. Shell Programming and Scripting

print in reverse order

Hi, I want to print the item in reverse order such that the output would look like 00 50 50 23 40 22 02 96 Below is the input: 00 05 05 32 04 22 20 69 Video tutorial on how to use code tags in The UNIX and Linux Forums. (5 Replies)
Discussion started by: reignangel2003
5 Replies

4. UNIX for Dummies Questions & Answers

printing fields in reverse order

command/script(apart from awk) to print the fields in reverse order that is last field has to come first and so on and first field has to go last Input store-id date sale ............. ............. ... (3 Replies)
Discussion started by: tsurendra
3 Replies

5. UNIX for Dummies Questions & Answers

How to print arguments in reverse order?

Hey all, How do I make a script print its arguments in reverse order? Thanks (5 Replies)
Discussion started by: unclepickle1
5 Replies

6. Shell Programming and Scripting

How to get fields in reverse order?

i am having lines like below seperated by "|" (pipe) abc|xyz 123|567 i have to get the above in reverse order xyz|abc 567|123 Pls help (5 Replies)
Discussion started by: suryanarayana
5 Replies

7. UNIX for Dummies Questions & Answers

sort -reverse order

I need to sort the particular column only in reverse order how i can give it.. if i give the -r option the whole file is getting sorted in reverse order. 1st 2nd col 3rd C col 4th col 5th col ------------------------------------------- C... (7 Replies)
Discussion started by: sivakumar.rj
7 Replies

8. Shell Programming and Scripting

sort a file in reverse order

I a file with log entries... I want to sort it so that the last line in the file is first and the first line is last.. eg. Sample file 1 h a f 8 6 After sort should look like 6 8 f a h 1 (11 Replies)
Discussion started by: frustrated1
11 Replies

9. UNIX for Dummies Questions & Answers

using sed and regex to reverse order???

so i have been trying to learn how to manipulate text on my own and have gotten stumped... let's say i have a text file that says (highly simplified): people ordinary How would swap the order of the words.. I know i need to use sed and some kind of back reference but cannot make it... (2 Replies)
Discussion started by: urtherhoda
2 Replies
Login or Register to Ask a Question