Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to print empty line when the a field is changed
Top Forums Shell Programming and Scripting How to print empty line when the a field is changed Post 302205363 by Franklin52 on Saturday 14th of June 2008 02:13:22 PM
Old 06-14-2008
Code:
awk 'NR==1{v=$2}$2!=v{v=$2;print ""}1' file

I've tested the code with your file and it works fine for me....Smilie

Explanation:

Code:
NR==1{v=$2}

Assign the value of the 2nd field to variable v if the line number = 1

Code:
$2!=v{v=$2;print ""}

If variable v (the value of the 2nd field of the previous line) don't match with the 2nd field, assign the value of the 2nd field to variable v and print an empty line.

Code:
1' file

awk evaluates after the last close brace the 1 as true and the prints the entire line by default.

Regards
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed - print old line and new changed line

hello, i have a file "TEST" and want to change the digit(s) after "=" . but i also want to print the old entry with a comment (for information). i want to use "sed", is it possible ? file: TEST = 10 # comment default value: 0 sed , with "p" , i can print the old entry, but i want to... (2 Replies)
Discussion started by: bora99
2 Replies

2. Shell Programming and Scripting

how to print field n of line m

Hi everyone, I have a basic csh/awk question. How do I print a given field from a given line in a given file? Thanks in advance! (11 Replies)
Discussion started by: Deanne
11 Replies

3. UNIX for Dummies Questions & Answers

Help required on printing the line if third field is not a empty space

Hi Experts, I want to print the lines whose third field in non-empty/blank space. i.e. INPUT FILE/B] dcdccghjrry0yd cont dcdccttrk820529 cont rdekedfsSCr dcdccttrdky2d0y cont rdekedfsSC2 ... (3 Replies)
Discussion started by: krao
3 Replies

4. Shell Programming and Scripting

awk - if field is empty, move line to new file

I have a script with this statement: /usr/xpg4/bin/awk -F"" 'NR==FNR{s=$2;next}{printf "%s\"%s\"\n", $0, s}' LOOKUP.TXT finallistnew.txt >test.txt I want to include logic or an additional step that says if there is no data in field 3, move the whole line out of test.txt into an additional... (9 Replies)
Discussion started by: scriptr2be
9 Replies

5. Shell Programming and Scripting

awk print last line returns empty string

hello I have a file with lines of info separated with "|" I want to amend the second field of the last line, using AWK my problem is with geting awk to return the last line this is what I am using awk 'END{ print $0 }' myFile but I get an empty result I tried the... (13 Replies)
Discussion started by: TasosARISFC
13 Replies

6. Shell Programming and Scripting

print - for printing whole line, but delimeters are changed to spaces

Hi consider the source file R|field1|field2 using the print statement in awk prints it as R field1 field2 Is there an easier way to print the whole line in its original format (i.e. with | delimiters) than doing print $1"|"$2"|"$3 ?? Thanks Storms (1 Reply)
Discussion started by: Storms
1 Replies

7. Shell Programming and Scripting

print non empty column/field value

I have below file 25-09-2012 24-09-2012 19-09-2012 31-07-2012 30-04-2012 30-03-2012 ASIAEXFVNV N/A CEU 4 DMIRSOA N/A CAS 2 2 2 DMIRSOA N/A MIDMT 2 NFIAL22 N/A HVNY 11 11 11 NFIAL22 N/A NYAL3 11 11 11 NFIAL22 N/A NYCN 11 11 11 ... (4 Replies)
Discussion started by: manas_ranjan
4 Replies

8. Programming

[SOLVED] C++ print next line until line.empty

Hi, could you please help with the following: I have an input file like: one two three four five six I want to print the lines starting from 'three' to the empty line. Something like that: if ( line == "three" ) { while ( !line.empty() ) { cout <<... (0 Replies)
Discussion started by: apenkov
0 Replies

9. UNIX for Dummies Questions & Answers

Using awk to remove duplicate line if field is empty

Hi all, I've got a file that has 12 fields. I've merged 2 files and there will be some duplicates in the following: FILE: 1. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, 100 2. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, (EMPTY) 3. CDC, 54321, TEST3,... (4 Replies)
Discussion started by: tugar
4 Replies

10. Shell Programming and Scripting

Command/script to match a field and print the next field of each line in a file.

Hello, I have a text file in the below format: Source Destination State Lag Status CQA02W2K12pl:D:\CAQA ... (10 Replies)
Discussion started by: pocodot
10 Replies

LEARN ABOUT OSF1

sbig5

sbig5(5)							File Formats Manual							  sbig5(5)

NAME

       sbig5 - A character encoding system (codeset) for Traditional Chinese

DESCRIPTION

       The  Shift  Big-5  (sbig5)  codeset is a variant of the Big-5 codeset (see big5(5)). The only difference between these codesets is that the
       second byte of some Big-5 characters are mapped to different values in the Shift Big-5 codeset. The remapping is done to avoid having  some
       metacharacters like *, which has special meaning to UNIX commands, in the second byte of a 2-byte Big-5 character.

       The mappings of Big-5 characters to Shift Big-5 characters are as follows:

       ------------------------------------------------------------------------
       Big-5	 (2nd	Character Symbol   Shift Big-5 (2nd   Character Symbol
       byte)				   byte)
       ------------------------------------------------------------------------
       40		@		   30		      0
       5B		[		   31		      1
       5C				   32		      2
       5D		]		   33		      3
       5E		^		   34		      4
       5F		-		   35		      5
       60		`		   36		      6
       7B		{		   37		      7
       7C		|		   38		      8
       7D		}		   39		      9
       7E		~		   9F		      nil
       ------------------------------------------------------------------------

       The sbig5 codeset is not supported by a locale but only through codeset conversion.

   Codeset Conversion
       The following codeset converter pairs are available for converting Traditional Chinese characters between sbig5 and other encoding formats.
       Refer to iconv_intro(5) for an introduction to codeset conversion. For more information about the other codeset	for  which  sbig5  is  the
       input or output, see the reference page specified in the list item.  big5_sbig5, sbig5_big5

	      Converting from and to the Big-5 codeset: big5(5).

	      Note that Big-5 encoding is equivalent to the Microsoft code-page format used on PCs for Traditional Chinese. Therefore, you can use
	      these converters to convert Traditional Chinese between PC code-page format and Shift Big-5 encoding.  eucTW_sbig5, sbig5_eucTW

	      Converting from and to Taiwanese Extended UNIX Code: eucTW(5).

SEE ALSO

       Commands: locale(1)

       Others:	ascii(5),  big5(5),  Chinese(5),  code_page(5),  dechanyu(5),  dechanzi(5),  eucTW(5),	GBK(5),  i18n_intro(5),  i18n_printing(5),
       iconv_intro(5), l10n_intro(5), telecode(5)

																	  sbig5(5)
All times are GMT -4. The time now is 05:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy