use awk to replace empty fields with the latest nonempty field

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
use awk to replace empty fields with the latest nonempty field

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Using sed to remove lines where field is empty	figaro	Shell Programming and Scripting	4	09-01-2009 04:07 PM
Count of Field for Non-Empty	Swapna173	UNIX for Dummies Questions & Answers	2	08-08-2008 10:48 AM
Awk scrip to remove empty field	bombcan	Shell Programming and Scripting	4	06-11-2008 01:57 PM
Compare dates in a field and print the latest date row	cvkishore	Shell Programming and Scripting	1	08-04-2007 08:58 AM
latest status of an field in a log file	encrypted	UNIX for Dummies Questions & Answers	2	07-16-2004 05:05 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

4 Weeks Ago

grossgermany grossgermany is offline

Registered User

Join Date: Jul 2007

Posts: 34

use awk to replace empty fields with the latest nonempty field

Hi suppose I have a csv file like this

Code:

count,1977,1978,1979
usa,         ,       , blue
japan,   red, yellow,green
india,        ,  yellow,blue
china,   blue, yellow, green

I want the output to be(replace everything, including empty data, with the most recent data):

Code:

count,1977,1978,1979
usa,     blue, blue, blue
japan,   green, green,green
india,    blue,  blue,blue
china,   green, green, green

how to do this in awk? thanks.

Last edited by Franklin52; 4 Weeks Ago at 09:20 AM.. Reason: Please use code tags!

Bookmarks

« Sed usage | No logro solucionar sacar el dia de la semana de una fecha dada. »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 12:38 PM.