Search Results

Hi I got it fixed.

As i m redirecting to the same file it was not working.
So i used outfile to get the result and used a mv command

awk -F"|" '{ idx=$2 FS $3 FS $4 FS $5; sum[idx] += $7;...

I tried them...Still not working.

sixth[name] and not sixth[idx].. sorry.. but still not working :mad:

Hi Vgersh,

This command is working perfect in command line.

when i m using this code it gives an error "
awk: sum is not an array"

Can u please help. Sorry to bother you again. Thanks a...

Thanks a lot Deepak.

Vgersh helped me in doing my task with awk command.

to find and group records in file. Please have a look at this thread for more in detail.

Thanks again for your help....

Wow Wow Wow!!!!!!!!
I Couldnt Say Anything... Awesome...
U R A Real Genius... Great And Thanks A Ton...
This Was Bugging Me For Last 3 Days... Great Relief... Thanks A Million :d

Hi Vgersh,

Thanks for your response. But the code

sum[$1 FS $2 FS $3 FS $4 FS $5] will compare fields from 1 to 5.

I need to comapre fields from 2 to 5 and aggregate, while printing i...

Hi Deepak,

Thanks for your reply.

but i did not fully get you.

Do u mean to say that i should do like this?

while read line
do
str=`echo $line | awk '{split($0, date,"|"); print...

Vgersh,
WOW!!! Thats great and helped me..

but when i use this command,

awk -F"|" '{ sum[$2 FS $3 FS $4 FS $5] += $7 } END { for (name in sum) print name"|"sum[name] }' data_file

it prints...

I Have a file

34EMEA|VODAFONE ES|5484|CPN|04/01/07|1|300
34LA|VODAFONE ES|5484|CPN|04/01/07|1|300

how can i aggregate it to
34EMEA|VODAFONE ES|5484|CPN|04/01/07|1|600

awk -F"|" '{ sum[$4]...

Hi

can you also tell me how i can acheive the below


i have a code in which i assign a value to a str variable.
Say line contains,
line=Field|Location ES|comp|dur|10

str=`echo $line |...

Hi I have a string variable

>Cat input.dat

This is a TEXT
This is a No

str="This is a TEXT"
cat input.dat | grep "$str" works fine in command line

but when i use it in shell script it...