Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

In a file, replace blank line by the last line not blank above

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting In a file, replace blank line by the last line not blank above
# 8  
Old 02-26-2017
General solution:
Code:
awk '{for(i=1; i<=NF; i++) if($i=="") $i=p[i]; else p[i]=$i}1' FS=\; OFS=\;  file


--
Note: one needs to test if the field is empty, otherwise it will fail if the one of the fields is the number "0"
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Deleting the last non blank line from a file

PGW|PGW_CDR_|2017-06-23 141946|2017-07-17 131633|2017-08-21 PGW|PGW_CDR_|2017-06-23 141946|2017-07-17 131633|2017-08-21 PGW|PGW_CDR_|2017-06-23 141946|2017-07-17 131633|2017-08-21 PGW|PGW_CDR_|2017-06-23 141946|2017-07-17 131633|2017-08-21 PGW|PGW_CDR_|2017-06-23 141946|2017-07-17... (6 Replies)
Discussion started by: swathi reddy1
6 Replies

2. Shell Programming and Scripting

Need help to replace a pattern with a blank line

Need help to replace the line beginning with tcp_sendspace with a blank line. # cat if en0: flags=1e080863,480<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),CHAIN> inet 10.27.53.21 netmask 0xffffff00 broadcast 10.207.52.255 inet... (11 Replies)
Discussion started by: sags007_99
11 Replies

3. Shell Programming and Scripting

replace blank line number

hlow all i need help how can i replace blank number with awk input.txt 300::|355264313178490 301::|358814003239510 302::|358316038113400 303::|357954002633660 304::|354072040694090 305::|356956015214190 306::|352943020525180 307::|359574033836610 308::|381810990023580 so will be like... (4 Replies)
Discussion started by: zvtral
4 Replies

4. Shell Programming and Scripting

Fill the empty line by adding line before blank line

FIle A "A" 2 aa 34 3 ac 5 cd "B" 3 hu 67 4 fg 5 gy output shud be A"" 2 aa 34 "A" 3 ac 34 "A" 5 cd 34 "B" 3 hu 67 "B" 4 fg 67 "B" 5 gy 67 (6 Replies)
Discussion started by: cdfd123
6 Replies

5. Shell Programming and Scripting

Replace two blank line with a single blank line

Hi Guys, I have a file in which each set of records are separated by two blank line. I want to replace it with a single blank line. Can you guys help me out? Regards, Magesh (9 Replies)
Discussion started by: mac4rfree
9 Replies

6. Shell Programming and Scripting

how to replace a line in file with blank line

Hi I nned cmd to which will help me to replace a line in file with blank line e.g. file1 a b c d e after running cmd I shud get file1 b c d e (5 Replies)
Discussion started by: tarunn.dubeyy
5 Replies

7. Shell Programming and Scripting

how to get the blank line number of a file?

I want to get the blank line number of a file. example: 9000|9000|WW|1|1|SL|472|472|LC|2272|1072|MTY|niceDay 9000|9000|WW|1|1|SL|470|470|MC|1270|1172|MPVT|nice 9000|9000|WW|1|1|SL|472|472|LC|1072|1672|MBD|Sonice 9000|9000|WW|1|1|SL|473|473|LF|1173|1173|MTY|nice666 I want to get... (5 Replies)
Discussion started by: robbiezr
5 Replies

8. Shell Programming and Scripting

Remove last blank line of file

I have a number of files (arranged in directories) which have last line blank, I am trying to synchronize my code with other env and due to this blank lines, all files error out as different although only difference is that of balnk line at end of file. Is there a way I can recursively... (2 Replies)
Discussion started by: ruchimca
2 Replies

9. Shell Programming and Scripting

ignoring blank line in a file

i have a file called Cleaner1.log . This files have some blank lines also.My requirement is that it should ignore the blank lines and give me the lines that contain some data. I m using this logic in a script: below the contents of file : Maximum Time Taken for Processing(Failed) RR... (4 Replies)
Discussion started by: ali560045
4 Replies

10. Shell Programming and Scripting

how to delete a first blank line from the file

I have a file which has the first blank line: sundev22$cat /t1/bin/startallocs /t1/bin/startallocsys 123 sundev22$ Is there a command to remove this first blank line? Thanks for help -A (4 Replies)
Discussion started by: aoussenko
4 Replies
Login or Register to Ask a Question

LEARN ABOUT SUSE

tabs

tabs(1) 						      General Commands Manual							   tabs(1)

NAME

       tabs - set tabs on a terminal

SYNOPSIS

       tabs [-v[n]] [-ahuUV] file...

DESCRIPTION

       The  tabs program clears and sets tab-stops on the terminal.  This uses the terminfo clear_all_tabs and set_tab capabilities.  If either is
       absent, tabs is unable to clear/set tab-stops.  The terminal should be configured to use hard tabs, e.g.,

	      stty tab0

OPTIONS

   General Options
       -Tname
	    Tell tabs which terminal type to use.  If this option is not given, tabs will use the $TERM environment variable.  If that is not set,
	    it will use the ansi+tabs entry.

       -d   The  debugging  option  shows  a ruler line, followed by two data lines.  The first data line shows the expected tab-stops marked with
	    asterisks.	The second data line shows the actual tab-stops, marked with asterisks.

       -n   This option tells tabs to check the options and run any debugging option, but not to modify the terminal settings.

       The tabs program processes a single list of tab stops.  The last option to be processed which defines a list is the one that determines the
       list to be processed.

   Implicit Lists
       Use a single number as an option, e.g., "-5" to set tabs at the given interval (in this case 1, 6, 11, 16, 21, etc.).  Tabs are repeated up
       to the right margin of the screen.

   Explicit Lists
       An explicit list can be defined after the options (this does not use a "-").  The values in the list must be in increasing  numeric  order,
       and greater than zero.  They are separated by a comma or a blank, for example,

	      tabs 1,6,11,16,21
	      tabs 1 6 11 16 21
       Use a '+' to treat a number as an increment relative to the previous value, e.g.,

	      tabs 1,+5,+5,+5,+5
       which is equivalent to the 1,6,11,16,21 example.

   Predefined Tab-Stops
       X/Open defines several predefined lists of tab stops.

       -a   Assembler, IBM S/370, first format

       -a2  Assembler, IBM S/370, second format

       -c   COBOL, normal format

       -c2  COBOL compact format

       -c3  COBOL compact format extended

       -f   FORTRAN

       -p   PL/I

       -s   SNOBOL

       -u   UNIVAC 1100 Assembler

PORTABILITY

       X/Open describes a +m option, to set a terminal's left-margin.  None of the entries in the terminal database provide this capability.

       The -d (debug) and -n (no-op) options are extensions not provided by other implementations.

       Documentation  for  other  implementations states that there is a limit on the number of tab stops.  While some terminals may not accept an
       arbitrary number of tab stops, this implementation will attempt to set tab stops up to the right margin of the screen, if  the  given  list
       happens to be that long.

SEE ALSO

       tset(1), infocmp(1), ncurses(3NCURSES), terminfo(5).

       This describes ncurses version 5.7 (patch 20100109).

																	   tabs(1)