Shell Programming and Scripting

Guys,,

I have a csv file. it has few columns... may be 3 or 4. I have the columns to be

1007 | gett | 234
1007 | pitt | 256
1007 | gett | 234
1007 | uitt | 245

Now i need to check all the rows of the first column. All the values present shd be 1007.
even if 1 value changes, i should get an error message.

NOTE : I get the 1007 value from another variable. with that value i should compare the first column in the file. please help me on this..

Thanks in advance

Are you trying to list all rows where that first column is NOT 1007?

I just want to check if all the rows are 1007 in that first column... if so, print a "success message", even if one row is not 1007, then i need to print a "Wrong message"

the commnad

Code:

grep -cv "^1007 |" <rgk.csv

will give you the count of lines that do not begin with your desired text

But 1007 is not the value i want.. i just gave it as an example. I get that value from a variable.that part of calculation i ve done. how do i search that obtained value here..

thanks in advance

Code:

value=1007

awk -v var=$value -F"|" '$1 == value{print "Row " NR ": success";next}{print "Row " NR ": wrong"}' file

I am using a file called "test.csv" that is so:

Code:

1007 , gett , 234
1007 , pitt , 256
1007 , gett , 234, 3
1007 , uitt , 245

(note blank lines and the 4 fields on line 3...)

Now the perl script:

Code:

$ perl -nle '$t=/^\s*(1007)\s*,/; die "wrong message\n" if(!$t && /,/);} { print "success!\n\n";' test.csv
success!

If I change any of the "1007" to anything else, I get "wrong message"

Is that what you are looking for?

Or you could use:

Code:

perl -nle 'BEGIN {$s=shift;} $t=/^\s*($s)\s*,/; die "wrong message\n" if(!$t && /,/);} { print "success!\n\n";' 1007 test.csv

if you want values different than "1007"