UNIX for Advanced & Expert Users

Hi ctsgnb,

The command "awk 'p!=$1{if(p)print p,s,t;s=t=x;p=$1}{s+=$2;t+=$3}END{print p,s,t}' $FILE/ban.txt > $FILE/banresult.txt" is working fine for first 6 lines and for rest of the line it shows 0.

I have 100 lines in a file, please let me know if im doing any mistake!!!
Prd c1 c2
bag 12 12
bag 18 15
bags 15 13
bags 15 14
blazer 24 24
blazer 33 32
boots 19 15
cardigan 12 11
cardigan 31 30
cardigan 32 27
chino 12 10
clearance 11 10
clearance 11 9
coat 22 20
coat 29 24
coats 15 13
cologne 18 18
cologne 19 17
dress 63 56
dress 71 59
dresses 14 12
dresses 94 86
dresses 96 80
fragrance 11 11
handbags 11 9
handbags 18 17
hats 13 9
jackets 16 14
jeans 24 21
jeans 28 21
leather%20jacket 20 20
leather%20jacket 28 27
leggings 19 19
leggings 29 26
mad%20men 104 89
mad%20men%20collection 14 14
mad%20men 21 18
mad%20men 99 89
man 11 10
maternity 15 15
maternity 21 18
men 26 24
men 28 21
men 75 67
men 88 75
mens%20shoes 13 13
monogram 11 11
order%20status 34 33
order%20status 42 36
palisades%20tote 14 13
palisades%20tote 16 13
pants 11 10
pants 12 11
perfume 12 11
perfume 47 45
perfume 53 44
petite 13 13
petite 21 18
polka%20dot 14 14
purse 12 8
purse 13 11
sale 40 39
sale 48 41
scarf 18 18
scarf 20 17
shirts 19 16
shoes 42 42
shoes 49 43
shorts 29 28
shorts 31 29
shorts 37 33
shorts 42 37
size%20chart 14 13
size%20chart 18 18
skirt 14 14
skirts 11 9
Sloan 13 11
suits 17 16
suits 18 17
sweater 24 24
sweater 30 26
sweaters 14 10
swim 12 11
swim 12 12
swim 14 14
swim 17 14
ties 12 6
tops 11 9
tote 11 11
trench%20coat 11 11
trench%20coat 17 16
trench 35 33
trench 47 41
vest 30 30
vest 33 32
vest 41 36
vest 49 41
women 11 9
women 44 37
women 57 49

And also please let me know, how to remove a double/triple space between c1 & c2 and make it single space line.

Regards
Wintech

I am working in centos unix os. My sort command is not working. Consider the following file
1008 Vijay 40
1009 Rekha 34
1010 Shreyas 40
1011 Sanjay 40
sort emp is not working
Can you send the options in sort command

What are your requirement ?

I already answered to your questions in some previous posts

Did your requirements change ?

If so, please create a new thread with a full description of what input you have and what output you expect.

Hi ctsgnb,

No!! my requirement is not changed

Yes you have answered my requirement, but the command which you gave works only for first 6 lines and rest shows 0..... Can i know why it shows 0 from 7th line till 100th line.

Regards
Wintech

You want to sort per employee name ?

If they are in column 2

then use

Code:

... | sort -k 2

---------- Post updated at 09:49 AM ---------- Previous update was at 09:43 AM ----------

Otherwise :

1. upload your input file
2. please copy paste exactly the command you have tried
3. please describe what is the problem

---------- Post updated at 09:51 AM ---------- Previous update was at 09:49 AM ----------

the command

Code:

awk 'p!=$1{if(p)print  p,s,t;s=t=x;p=$1}{s+=$2;t+=$3}END{print p,s,t}' $FILE/ban.txt >  $FILE/banresult.txt

IS NOT the command i suggested in my previous posts ...

Or are you mixing this thread with another one ?

@ctsgnb: The user who posted a question in post #9 (jpachar) is different from the user who created this thread (Paulwintech)

@jpachar: Please create a new thread.

There is no error as such, but the records are not sorted. I gave the command sort emp.