Search Results

awk obviously does what you want:

$ printf "\tASDF\n" | awk -F'\t' '$1' # Ignore lines where first field is blank

$ So, your data doesn't seem to be what you think it is.As such, using a...

Some options:
awk -F'\t' '$1!=""' infile
or
awk -F'\t' 'x$1' infile
You can use single quotes to protect \t from interpretation by the shell..

-or just-
awk '!/^\t/' infile
for the first...

Other way:

$ awk 'BEGIN { FS = "," } $3 ~ /F-/ { print $0 ",\"Female\""; next } $3 ~ /M-/ { print $0 ",\"Male\""; next } { print $0 ",\"Unknown\"" }' infile...

Something similar...

awk -F, '
$3~"F-\""||$7~"F-\""{print $0OFS"\"Female\"";next}
$3~"M-\""||$7~"M-\""{print $0OFS"\"Male\"";next}
{print $0 OFS"\"Unknown\""} ' OFS=, infile


--ahamed
...

Something like this should work:



awk '
{
if( match( "F-", $3 $7 ) )
s = "Female";
else
if( match( "M-", $3 $7 ) )
s = "Male";
...

You are right!...

--ahamed

awk '/2011-11-05/ {$6=$5}1' FS=, OFS=, File1.txt
You can refer it to finish your second request.

grep -vf vitallog.txt vitalinfo.txt > vitalfiltered.txt



awk -F, 'NR==FNR{_1[$1]++;next}!_1[$1]' vitallog.txt vitalinfo.txt > vitalfiltered.txt

--ahamed

awk -F, '{a[$1]++} END{for(row in a) if(a[row]==1) print row}' file*