# Linux script

**URL:** <https://community.unix.com/t/linux-script/320423>\
**Category:** Shell Programming and Scripting\
**Created:** [November 27, 2012, 5:26am UTC](https://community.unix.com/t/linux-script/320423 "2012-11-27T05:26:10Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![pradeep\_rawat](https://community.unix.com/letter_avatar/pradeep_rawat/32/6_449c533f586939b6e5f246632a46421f.png) [@pradeep\_rawat](https://community.unix.com/u/pradeep_rawat)\
**Post date:** [November 27, 2012, 5:26am UTC](https://community.unix.com/t/linux-script/320423/1 "2012-11-27T05:26:10Z")

</div>

can anyone help in this  
i have a file like

```nohighlight
2089,success
2089,failure
2087,failure
2089,success
2087,failure.

```

i want output like.

```nohighlight
2089,success=2,failure=1
2087,success=1,failure=2

```

thanks

---

<div class="post-metadata">

**Author:** ![Jotne](https://community.unix.com/user_avatar/community.unix.com/jotne/32/2148_2.png) [@Jotne](https://community.unix.com/u/Jotne)\
**Post date:** [November 27, 2012, 6:42am UTC](https://community.unix.com/t/linux-script/320423/2 "2012-11-27T06:42:11Z")

</div>

Not exact what you like, but mat help you on you way

```nohighlight
awk '{arr[$1]++; next} END {for (i in arr) { print i,arr }}' file

```

gives

```nohighlight
2089,failure 1
2087,failure 2
2089,success 2

```

---

<div class="post-metadata">

**Author:** ![pamu](https://community.unix.com/letter_avatar/pamu/32/6_449c533f586939b6e5f246632a46421f.png) [@pamu](https://community.unix.com/u/pamu)\
**Post date:** [November 27, 2012, 7:10am UTC](https://community.unix.com/t/linux-script/320423/3 "2012-11-27T07:10:02Z")

</div>

Try

```nohighlight
$ cat file
2089,success
2089,failure
2087,failure
2089,success
2087,failure

$ awk -F, -v SU="success" -v FA="failure" '{X[$1]++;Y[$1,$2]++;next}END{for(i in X){print i",",SU,Y[i,SU]?Y[i,SU]:0,","FA,Y[i,FA]?Y[i,FA]:0}}' file
2087, success 0 ,failure 2
2089, success 2 ,failure 1

```

---

<div class="post-metadata">

**Author:** ![Jotne](https://community.unix.com/user_avatar/community.unix.com/jotne/32/2148_2.png) [@Jotne](https://community.unix.com/u/Jotne)\
**Post date:** [November 27, 2012, 7:26am UTC](https://community.unix.com/t/linux-script/320423/4 "2012-11-27T07:26:55Z")

</div>

Can you explain the `?Y[i,SU]:0` in `Y[i,SU]?Y[i,SU]:0` ?

Edit: Found it.  
Print a `0` instead of `blank` if no hits 🙂

---

<div class="post-metadata">

**Author:** ![pradeep\_rawat](https://community.unix.com/letter_avatar/pradeep_rawat/32/6_449c533f586939b6e5f246632a46421f.png) [@pradeep\_rawat](https://community.unix.com/u/pradeep_rawat)\
**Post date:** [November 27, 2012, 8:33am UTC](https://community.unix.com/t/linux-script/320423/5 "2012-11-27T08:33:21Z")

</div>

@pamu= its not increasing the value of success and failure its jst giving output lik this  
2089, success 0 ,failure 0

---

<div class="post-metadata">

**Author:** ![Jotne](https://community.unix.com/user_avatar/community.unix.com/jotne/32/2148_2.png) [@Jotne](https://community.unix.com/u/Jotne)\
**Post date:** [November 27, 2012, 8:53am UTC](https://community.unix.com/t/linux-script/320423/6 "2012-11-27T08:53:41Z")

</div>

Works fine. Try this.

```nohighlight
echo "2089,success
2089,failure
2087,failure
2089,success
2087,failure
3011,success
2089,failure
3011,success
2087,failure
3011,success" | awk -F, -v SU="success" -v FA="failure" '{X[$1]++;Y[$1,$2]++;next}END{for(i in X){print i",",SU,Y[i,SU]?Y[i,SU]:0,","FA,Y[i,FA]?Y[i,FA]:0}}'

```

Gives

```nohighlight
2087, success 0 ,failure 3
3011, success 3 ,failure 0
2089, success 2 ,failure 2

```

---

<div class="post-metadata">

**Author:** ![Scrutinizer](https://community.unix.com/user_avatar/community.unix.com/scrutinizer/32/1216_2.png) [@Scrutinizer](https://community.unix.com/u/Scrutinizer)\
**Post date:** [November 27, 2012, 9:19am UTC](https://community.unix.com/t/linux-script/320423/7 "2012-11-27T09:19:00Z")

</div>

Alternatively:

```nohighlight
awk -F, '{A[$1]; B[$2]; C[$1,$2]++} END{for(i in A){p=i; for(j in B)p=p FS j "=" C[i,j]+0; print p}}' file

```

---

<div class="post-metadata">

**Author:** ![pradeep\_rawat](https://community.unix.com/letter_avatar/pradeep_rawat/32/6_449c533f586939b6e5f246632a46421f.png) [@pradeep\_rawat](https://community.unix.com/u/pradeep_rawat)\
**Post date:** [November 28, 2012, 1:05am UTC](https://community.unix.com/t/linux-script/320423/8 "2012-11-28T01:05:56Z")

</div>

thnx everyone 🙂 @Scrutinizer = can u explain me d codes please 🙂

---

<div class="post-metadata">

**Author:** ![Jotne](https://community.unix.com/user_avatar/community.unix.com/jotne/32/2148_2.png) [@Jotne](https://community.unix.com/u/Jotne)\
**Post date:** [November 28, 2012, 1:47am UTC](https://community.unix.com/t/linux-script/320423/9 "2012-11-28T01:47:43Z")

</div>

I will try to explain it, not sure I get all of it 🙂  
`-F,` sets the filed separator to `,` , normal ` ` (1 space)  
`{A[$1]; B[$2]; C[$1,$2]++}` reads all data into three array  
`A` contains all numbers  
`B` contains success or failure  
`C` contains both

Everything is printed out.

```nohighlight
END{for(i in A){p=i; for(j in B)p=p FS j "=" C[i,j]+0; print p}}

```

`for(i in A)` Starts a loop, one for each number  
`for(j in B)` then start a new loop within the first loop to select `success` or `failure`  
`+0` if no hits are found, it normally prints a blank, but by adding `0` , it show `0` when nothing found. Some more simple solution compare a conditional test done here: `C[i,j]?C[i,j]:0`

```nohighlight
1. first run of loop i give i=2089 p=i=2089
    a. first run of loop j gives j=success p=p=2089 + FS="," + j=success + "=" +numbers of success+0
    b. second run of loop j gives j=faulure p=p=2089,success=2 +FS="," + j=failure + "=" +numbers of failure+0
       This gives p=2089,success=2,failure=1 then print p

2. second run of loop i give i=2087 p=i=2087
    a. p=2087,success=0
    b. p=2087,success=0,failure=2
        print p=2087,success=0,failure=2

```
