10-21-2009
Quote:
Originally Posted by
rudoraj
Great this gives number of recrods. Would it be possible to print the lines instead?
You can put whatever you want it to do inside the braces.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have some csv files out of which i want to find records which have empty values in either the 14th or 16th fields.
The following is a sample.
$cut -d',' -f14,16 SPS* | head -5
VOIP_ORIG_INFO,VOIP_DEST_INFO
sip:445600709315@sip.com,sip:999@sip.com... (2 Replies)
Discussion started by: rahulrathod
2 Replies
2. Shell Programming and Scripting
Hi,
I have a file with 104 columns delimited by comma.
I have to replace fields 4,5 and 19 with null values and after replacing the columns in the file , the file should be still comma delimited. I am new to shell scripting, Experts please help me out.
Thank you (1 Reply)
Discussion started by: vukkusila
1 Replies
3. Shell Programming and Scripting
Hi,
can I do something like this to add a condition of checking if the 4th field is number or space or blank also:
awk -F, '$4 /^*||*/' MYFILE >> OTHERFILE
I also want the other part i.e. I need to exclude all lines whose 4th field is space or blank or number:
MYFILE
a,b,c,d,e
a,b,c,2,r... (2 Replies)
Discussion started by: praveenK_Dudala
2 Replies
4. Shell Programming and Scripting
Hi, everyone
I have a requirement as following:
source file
1, abc, def, caaa
2, , cde, aaa
3, bcd, , adefefg
I need find columns which contains null value, in above example,
I need get two rows
2, , cde, aaa
3, bcd, , adefefg
anybody has idea how to achive this
... (5 Replies)
Discussion started by: ken002
5 Replies
5. Shell Programming and Scripting
Hello Gurus !
I have what probably amounts to a few simply changes to fix; however for the life of me I cannot seem to get it ti work. I need to align the output of my script (I am writing to a logfile)... here's the lines in my code:
if
then
echo "NODE: $node" >> $logfile... (6 Replies)
Discussion started by: gvolpini
6 Replies
6. Shell Programming and Scripting
Hi,
I am trying to find the lines in a pipe delimited file where 11th column has not null values. Any help is appreciated. Need help asap please.
thanks in advance. (3 Replies)
Discussion started by: manikms
3 Replies
7. Shell Programming and Scripting
I need to find (basically, grep) matching lines ignoring the first field from file1:
field1 field2 field3 field4 field5 field6
id1 carrot white small
id2 carrot
id3 potato black
id4 potato
in file2:
field1 field2 field3 field4 field5 field6
num1 carrot white ... (2 Replies)
Discussion started by: coppuca
2 Replies
8. UNIX for Dummies Questions & Answers
Hello All,
I am new to unix scripting and wanted to know, is it possible if we find any null value or blank record in the text file.
For example we have a text file with only one column and there are 90 records.
But some times we will have a null value or blank row record in the text file.
I... (4 Replies)
Discussion started by: Ram11111
4 Replies
9. Shell Programming and Scripting
The below code runs and creates an output file with three sections. The first 2 sections are ok, but the third section doesn't seem to put a . in all the fields that are blank. I don't know if this is what causes the last two fields in the current output to shift to a newline, but I can not seem... (3 Replies)
Discussion started by: cmccabe
3 Replies
10. Shell Programming and Scripting
Hi All
My requirement is to find the null values in particular column of a file and reject it in case if it contains null values. But the challenge is that I want a common command which can be used across different file, as the position of the column we need to check for different file may get... (14 Replies)
Discussion started by: ginrkf
14 Replies
LEARN ABOUT MOJAVE
file::find::rule::extending
File::Find::Rule::Extending(3) User Contributed Perl Documentation File::Find::Rule::Extending(3)
NAME
File::Find::Rule::Extending - the mini-guide to extending File::Find::Rule
SYNOPSIS
package File::Find::Rule::Random;
use strict;
# take useful things from File::Find::Rule
use base 'File::Find::Rule';
# and force our crack into the main namespace
sub File::Find::Rule::random () {
my $self = shift()->_force_object;
$self->exec( sub { rand > 0.5 } );
}
1;
DESCRIPTION
File::Find::Rule went down so well with the buying public that everyone wanted to add extra features. With the 0.07 release this became a
possibility, using the following conventions.
Declare your package
package File::Find::Rule::Random;
use strict;
Inherit methods from File::Find::Rule
# take useful things from File::Find::Rule
use base 'File::Find::Rule';
Force your madness into the main package
# and force our crack into the main namespace
sub File::Find::Rule::random () {
my $self = shift()->_force_object;
$self->exec( sub { rand > 0.5 } );
}
Yes, we're being very cavalier here and defining things into the main File::Find::Rule namespace. This is due to lack of imaginiation on
my part - I simply can't find a way for the functional and oo interface to work without doing this or some kind of inheritance, and
inheritance stops you using two File::Find::Rule::Foo modules together.
For this reason try and pick distinct names for your extensions. If this becomes a problem then I may institute a semi-official registry
of taken names.
Taking no arguments.
Note the null prototype on random. This is a cheat for the procedural interface to know that your sub takes no arguments, and so allows
this to happen:
find( random => in => '.' );
If you hadn't declared "random" with a null prototype it would have consumed "in" as a parameter to it, then got all confused as it doesn't
know about a '.' rule.
AUTHOR
Richard Clamp <richardc@unixbeard.net>
COPYRIGHT
Copyright (C) 2002 Richard Clamp. All Rights Reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
File::Find::Rule
File::Find::Rule::MMagic was the first extension module, so maybe check that out.
perl v5.18.2 2011-09-19 File::Find::Rule::Extending(3)