Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Select a portion of file based on query
Top Forums Shell Programming and Scripting Select a portion of file based on query Post 302092926 by anbu23 on Friday 13th of October 2006 01:06:31 PM
Old 10-13-2006
Quote:
Originally Posted by vanand420
Hi friends Smilie
I am having a small problem and ur help is needed...
I have a long file from which i want to select only some portions after filtering (grep).
My file looks like :

header
xxyy
lmno
xxyy
wxyz
footer

header
abcd
xy
pqrs
footer
.
.

I want to select the block of lines between header and footer based on search given suppose I give 'xy' then the complete block from header to footer where xy exist should be selected..
I was using command : awk '/header/,/footer/' But confused where to insert the search criteria in this command
Please help me
Thanks in advance...
Code:
awk ' BEGIN { RS = "" ; FS = "\n" }
{ flag=0;
for( i = 1 ; i <= NF; ++i )
{
if(match ( $i , "^xy$" ))
        {  flag=1;break;  }
}
if( flag == 1 ) print
} ' file

Last edited by anbu23; 10-13-2006 at 03:04 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk program to select a portion of a line

Hi all, I am new to awk programs.I have a file like this vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd... (3 Replies)
Discussion started by: anju
3 Replies

2. Shell Programming and Scripting

select a portion of a file into a CSV

How will i convert a file <LDATE>10-12-07</LDATE><LTIME>13:47:48.553</LTIME><LTEXT>name:anju;city:blore;ph:123</LTEXT> <LDATE>10-12-07</LDATE><LTIME>13:47:48.553</LTIME><LTEXT>name:anju;city:blore;ph:123</LTEXT>... (8 Replies)
Discussion started by: anju
8 Replies

3. UNIX for Dummies Questions & Answers

Reading from a file and passing the value to a select query

Hi all, Here is my problem. I want to read data from a file and pass the variable to a select query. I tried but it doesn't seem to work. Please advise. Example below. FileName='filekey.txt' while read LINE do var=$LINE print "For File key $var" ${ORACLE_HOME}/bin/sqlplus -s... (1 Reply)
Discussion started by: er_ashu
1 Replies

4. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi , I just found you while surfing for the string 'Redirecting sql select query output from within a shell script to txt file/excel file' Could you find time sending me the code for the above question? It'll be great help for me. I have a perl file that calls the sql file... (1 Reply)
Discussion started by: dolphin123
1 Replies

5. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi Yogesh, Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel" I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies

6. UNIX for Advanced & Expert Users

need to get a portion of entries in file based on a criteria --- Help please

All, Below is the file, what i need to do is take the text in between the /*-- and --*/ , i mean the jobs. Then i have grep for system name . If the job is there in system 1 i have to print to a file. Basically i want to take all the jobs that are in system1 to another file . because... (7 Replies)
Discussion started by: arunkumar_mca
7 Replies

7. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

So, I would like to run differen select queries on multiple databases.. I made a script wich I thought to be called something like.. ./script.sh sql_file_name out.log or to enter select statement in a command line.. (aix) and I did created some shell script wich is not working.. it... (6 Replies)
Discussion started by: bongo
6 Replies

8. Shell Programming and Scripting

Rename portion of file based on another file

Hello, I've been searching and reading, but I can't figure out how to solve this problem with my newbie skills. In my directory, I have a list of files (see dirlist.txt attachment) that I need to merge and rename. I have part of the code of the code figured out (see below). However, I... (3 Replies)
Discussion started by: anjulka
3 Replies

9. Shell Programming and Scripting

Select lines from a file based on a criteria

Hi I need to select lines from a txt file, I have got a line starting with ZMIO:MSISDN= and after a few line I have another line starting with 'MOBILE STATION ISDN NUMBER' and another one starting with 'VLR-ADDRESS' I need to copy these three lines as three different columns in a separate... (3 Replies)
Discussion started by: Tlcm sam
3 Replies

10. UNIX for Dummies Questions & Answers

Select last update data based on file name

Hi All, I need to remove all files except the most update data based on date on filename Input data_AIDS_20150312.txt data_AIDS_20150311.txt data_AIDS_20150411.txt data_AIDS_20140312.txt the most updated data is data_AIDS_20150411.txt, so I'll remove other files. My expected output... (3 Replies)
Discussion started by: radius
3 Replies

LEARN ABOUT DEBIAN

ample.html

AMPLE.HTML(5)							    User Manual 						     AMPLE.HTML(5)

NAME

       ample.html - html template for Ample

DESCRIPTION

       This  file, by default /etc/ample/ample.html, is read by Ample at startup and used as a base for it's HTML pages.  These pages are rendered
       whenever  a  webbrowser	connects  and  requests  a  list  of  available  songs	and  directories  (typically   done   by   connecting	to
       http://server:port/index.html).

       The  file is divided into three sections, the header, the middle and the footer. The header and the footer are the same on each page gener-
       ated while the "middle" is copied into the final HTML document once for each file or directory that is going to be  listed.  Although  this
       may sound confusing, it will probably become much more evident once you look at the example below.

       Variables  are  written	in  uppercase  and enclosed within "at" signs (example: @NAME@) and are replaced dynamically when the page is con-
       structed.  Some variables can exist anywhere in the document and some can only exist in the "middle" section,  see  the	information  about
       each variable for details.

EXAMPLE


       <!-- Beginning of header -->
       <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
       <html><head>
       <title>@SERVERNAME@</title>
       </head><body>
       <center>
       <p><h1>@SERVERNAME@</h1></p>
       <p><h2>Tracks currently available in @PATH@</h2></p>
       <p><font size="-1">[
       <a href="index.m3u">playlist for this dir</a> |
       <a href="rindex.m3u">recursive playlist</a> ]
       </font></p>
       <p><font size="-1">
       [ <a href="../index.html">Up one level</a> ]
       </font></p>
       <div align="center">
       <table border="1" cellspacing="0" cellpadding="0" bordercolor="#000000">
       <tr><td>
       <b>TYPE</b>
       </td><td>
       <b>URL</b>
       </td></tr>
       <!-- End of header -->

       @BEGIN@

       <!-- Beginning of "middle" -->
       <tr><td>
       @TYPE@
       </td><td>
       <a href="@URL@">@NAME@</a>
       </td></tr>
       <!-- End of "middle" -->

       @END@

       <!-- Beginning of footer -->
       </table>
       </div>
       <p align="right"><font size="-1">
       powered by Ample, for more information, see the
       <a href="http://ample.sourceforge.net">project homepage</a>
       </font></p>
       </center>
       </body>
       </html>
       <!-- End of footer -->

SUMMARY OF VARIABLES


       SPECIAL - Only used once
       BEGIN
       END

       GLOBAL - Can be used anywhere
       SERVERNAME
       PORT
       PATH

       NON-GLOBAL - Can only be used in the "middle" section
       NAME
       URL
       LENGTH
       TITLE
       SIZE
       TYPE

SPECIAL VARIABLES

       These can only be used once.

       BEGIN  This  variable  (when  placed in the beginning of a new line) marks the end of the header section and the start of the "middle" sec-
	      tion.

       END    This variable (when placed in the beginning of a new line) marks the end of the "middle" section and the start of  the  footer  sec-
	      tion.

GLOBAL VARIABLES

       These can be used anywhere.

       SERVERNAME
	      The name of the server as given in ample.conf(5).

       PORT   The port that the server is listening to.

       PATH   The current path the user is viewing.

NON-GLOBAL VARIABLES
       These can only be used in the "middle" section.

       NAME   The name of the song or directory.

       URL    The URL of the song or directory.

       LENGTH The song length (in seconds) or blank if it is a directory.

       TITLE  The title of the song or "DIR" if it is a directory.

       SIZE   The file size or blank if it is a directory.

       TYPE   "FILE" if it is a file or "DIR" if it is a directory.

AUTHOR

       David Hardeman <david@2gen.com>

SEE ALSO

       ample(1), ample.conf(5)

Ample								   JANUARY 2002 						     AMPLE.HTML(5)
All times are GMT -4. The time now is 03:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy