Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk line extraction question
Top Forums Shell Programming and Scripting awk line extraction question Post 302413641 by danmero on Friday 16th of April 2010 12:33:25 PM
Old 04-16-2010
Quote:
Originally Posted by vgersh99
Code:
nawk '$2!=two{if(FNR>1)print prev;print ;two=$2}{prev=$0}' myFile

You have to print after the END otherwise you miss the last line.
Code:
 nawk '$2!=two{if(NR>1)print prev;print ;two=$2}{prev=$0}' file
NEW 0088-BPM 1.042700e+04 877168.19 9718360.00 1496.00
NEW 0088-BPM 1.043100e+04 877031.25 9718358.00 1505.00
NEW 7493-BPM 4.890000e+03 681176.38 9977126.00 11514.00

 nawk 'END{print prev}$2!=two{print ((NR-1)?prev RS:x)$0;two=$2}{prev=$0}' file
NEW 0088-BPM 1.042700e+04 877168.19 9718360.00 1496.00
NEW 0088-BPM 1.043100e+04 877031.25 9718358.00 1505.00
NEW 7493-BPM 4.890000e+03 681176.38 9977126.00 11514.00
NEW 7493-BPM 4.893000e+03 681243.00 9977217.00 11523.00

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SED scipt help - line extraction

Forgive me if this is a dumb question...I'm a Windows sys admin with little programming knowledge. I have files containing anywhere from 3 to 200 lines. Using SED, I want to extract only lines containing a specific instance of "ISS." It is possible that "ISS" will occur several times in a... (10 Replies)
Discussion started by: thuston22
10 Replies

2. Shell Programming and Scripting

AWK extraction

Hi all, Can anyone please help me in parsing the following file. Suppose the file is called, example.lst, and has the following content in it. (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 192.168.2.2) ... (3 Replies)
Discussion started by: harris2107
3 Replies

3. Shell Programming and Scripting

AWK end of line question

Any clues on how to parse a line returned from an ls command that allows for the filename to be fully passed even if it includes spaces? What I got close with is: ls -ltra | awk '{print $1 "|" $3 "|" $4 "|" $5 "|" $6 "|" $7 "|" $8 "|" $9 $10 $11 $12 ... (etc)}' However this clears the spaces in... (6 Replies)
Discussion started by: jpport123
6 Replies

4. Shell Programming and Scripting

AWK extraction

Hi all, I have a data file from which i would like to extract only certain fields, which are not adjacent to each other. Following is the format of data file (data.txt) that i have, which has about 6 fields delimited by "|" HARRIS|23|IT|PROGRAMMER|CHICAGO|EMP JOHN|35|IT|JAVA|NY|CON... (2 Replies)
Discussion started by: harris2107
2 Replies

5. Shell Programming and Scripting

extraction of last but one char in a line

I need to extract the character before the last "|" in the following lines, which are 'N' and 'U'. The last "|" shouldn't be extracted. Also the no.s of "|" may vary in a line, but I need only the character before the last one. ... (1 Reply)
Discussion started by: hidnana
1 Replies

6. Shell Programming and Scripting

Another data extraction question

Hi, I have a tmp file like below: <ADATA> ANUM=900 ADESC=Saving ATYP=0 TXREGD=0 </ADATA> <ADATA> ANUM=890 ADESC=Saving ATYP=0 ABAL=9000 TXREGD=1 </ADATA> <ADATA> (6 Replies)
Discussion started by: kunigirib
6 Replies

7. Shell Programming and Scripting

File extraction without awk

Hello everybody, Here is my problem : I cannot find a way to extract data from a particular file and more precisely I cannot extract the result of my awk script to an external file because I am currently working on HP-UX. I would like a simple script (without awk) which asks for a date like... (4 Replies)
Discussion started by: freyr
4 Replies

8. Shell Programming and Scripting

awk :quick question removing empty line.

How to write in awk to remove lines starting with "#" and then process the file: This is not working: cat file|awk '{if ($0 ~ /^#/) $0="";print NF>0}' When I just give cat file|awk '{if ($0 ~ /^#/) $0="";print }' it prints the blank lines . I don't wnat the blank lines along with the... (15 Replies)
Discussion started by: rveri
15 Replies

9. Shell Programming and Scripting

Multi line extraction based on condition

Hi I have some data in a file as below ****************************** Class 1A Students absent are : 1. ABC 2. CDE 3. CPE ****************************** Class 2A Students absent are : ****************************** Class 3A Students absent are : (6 Replies)
Discussion started by: reldb
6 Replies

LEARN ABOUT OSX

prev

PREV(1) 							     [nmh-1.5]								   PREV(1)

NAME

       prev - show the previous message

SYNOPSIS

       prev [+folder] [-showproc program] [-showmimeproc program] [-header | -noheader] [-checkmime | -nocheckmime] [switches for showproc or
	    showmimeproc] [-version] [-help]

DESCRIPTION

       Prev performs a show on the previous message in the specified (or current) folder.  Like show, it passes any switches  on  to  the  program
       named by showproc or showmimeproc, which is called to list the message.	This command is almost exactly equivalent to "show prev".  Consult
       the manual entry for show(1) for all the details.

FILES

       $HOME/.mh_profile	  The user profile

PROFILE COMPONENTS

       Path:		    To determine the user's nmh directory
       Current-Folder:	    To find the default current folder
       showproc:	    Program to show non-MIME messages
       showmimeproc:	    Program to show MIME messages

SEE ALSO

       show(1), next(1)

DEFAULTS

       `+folder' defaults to the current folder
       `-checkmime'
       `-header'

CONTEXT

       If a folder is specified, it will become the current folder.  The message that is shown (i.e.,  the  previous  message  in  sequence)  will
       become the current message.

BUGS

       prev  is  really  a link to the show program.  As a result, if you make a link to prev and that link is not called prev, your link will act
       like show instead.  To circumvent this, add a profile-entry for the link to your nmh profile and add the argument prev to the entry.

MH.6.8								   11 June 2012 							   PREV(1)
All times are GMT -4. The time now is 01:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy