Search Results

Hello siramitsharma,

If I understood your requirement correctly, could you please try following and let me know if this helps you.

echo "014387650" | awk '{n=split($0,...

As long as you keep us guessing (e.g. on you file structrue) and don't post exact specifications, I'm afraid we (at least I) can't help further.

Why don't you use the FILENAME variable for identifying the file being read?

If you're happy with the result, I think we're done. There's no file being iterated twice. And, instead of using substr several times, you could put its result into a variable and use that four times.

Sure:
!(NR%2){ # On every even line
print $1, A["KB"], A["MB"] # Print the first field, array element "KB" and "MB"
}

The array always has only two elements..

Try:
awk 'BEGIN{print "DATE,KB,MB"} {A[$2]=$3} !(NR%2){print $1, A["KB"], A["MB"]}' FS=, OFS=, file

DATE,KB,MB
01-APR-14,822714,8133431
02-APR-14,757140,7770368
03-APR-14,815427,7590511...

With maintaning order


sort -t, -k2 input_file | nawk -F, '{a[$1]=a[$1]?a[$1]FS$3:$1FS$3} END{for(i in a) print a[i]|"sort"}'

Hello,

If order doesn't matters then following may help you.



sort -t, -k2 check_change_check12113 | awk -F"\," 'BEGIN{print "DATE,KB,MB"} {a[$1]=a[$1] OFS $3} END{for(i in...

I would simplify like this
$ awk '{print $0,++a[$0]}' file

awk ' { arr[$0]++; print $0 "," arr[$0] } ' input

Should be:
awk -F, 'dupentries[$1,$2,$3,$4,$5,$6,$7,$8]++ {print > "Duplicates"; next}{print}' inputfile > inputfile.tmp

Hello,

Just add {print} in place of print.
It should work then.


Thanks,
R. Singh

Try:
awk -F, 'dupentries[$1,$2,$3,$4,$5,$6,$7,$8]++ {print > "Duplicates"; next};print' inputfile > inputfile.tmp
mv inputfile.tmp inputfile

awk -F"|" 'FNR==1{++cnt}
cnt==1{ACTFILE[$1]=$2"|"$3"|"$4"|"$5"|"$6;a[$1]=$7"000000";next}
cnt==2{DEACTFILE[$1]=$2"|"$3"|"$4"|"$5"|"$6;d[$1]=$7"000000";next}
{
if (ACTFILE[$1] && $5 gt a[$1] )...

You can try something like this, as Scrutinizer already suggested


awk '

FNR==1{
++counter
}
counter==1 {
ACTFILE[$1]=$2 FS...

Since you are only comparing dates and one date is in YYmmddHHMMSS format and the other in YYmmdd, you could just slap "000000" at the end of the latter and do a numerical comparison.

The problem is that the order of the elements accessed from an array by the awk command:
for (index in array) {
do stuff
}
is unspecified.

The index(string1, string2) function will...

Since you sent me private mail asking me to help you on this again, I take it that you ignored my previous messages in this thread. The archive files produced by awk contain lots of NULL bytes; so...

Like I said, replace the BEGIN by a main loop over the first file argument (file1).
The variable line becomes $0, and $1,$2 etc. are the fields of $0.
Further, awk does not accept if ... else if...

How about applying our advices and creating / testing a revised code. If that does not work, come back for help. One more comment: As the bb.txt file entries and thus BB elements are having 4 chars,...

You cannot use both stdin and file input like that, you would need the "-" file operand..
Try:
zcat samplefile.tar.gz | awk '...' bb.txt -

Try to change:

expect "password:" to

expect "Password:"