AWK - conditional cause

Rafael.Buria · #1 (**permalink**) 01-28-2008

Hello guys,

I want to make a conditional cause in the following file using awk:
awk '{ if ($2 != 0) print $1, $2, $3}' test.csv > test2.csv

FILE EXAMPLE = test.csv

string,number,date
abc,0,20050101
def,1,20060101
ghi,2,20040101
jkl,12,20090101
mno,123,20020101
pqr,1234,20020101
stu,0,20000101

However i always get in test2.csv the same content of test.csv. Does anyone know what is the problem with my statment?

Best Regards

jim mcnamara · #2 (**permalink**) 01-28-2008

Code:

awk -F, 'BEGIN {OSF=","} { if ($2 != 0) print $1, $2, $3}' test.csv > test2.csv

Rafael.Buria · #3 (**permalink**) 01-28-2008

thanks Jim...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Conditional FTP	Dastard	Shell Programming and Scripting	2	06-21-2008 07:38 AM
conditional email	ricky007	Shell Programming and Scripting	3	03-06-2008 01:38 AM
conditional statement	lalelle	Shell Programming and Scripting	8	08-21-2007 08:57 AM
conditional split	braindrain	Shell Programming and Scripting	5	03-11-2006 03:54 AM
Conditional Statements	cstovall	Shell Programming and Scripting	1	05-15-2005 05:58 PM

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


	Powered by