Search Results

+ + uniqsort -c

usage: grep [-E | -F] [-c|-l|-q] [-insvxbhwy] [-p parasep] -e pattern_list...
[-f pattern_file...] [file...]
usage: grep [-E | -F] [-c|-l|-q] [-insvxbhwy] [-p parasep]...

ins@ARTMGA01> more arc.sh

#!/bin/sh

set -x



for file in $(ls 0902*0010202.TLG); do

day=$(echo $file | cut -c 1-6)

grep ^203 $file | cut -d, -f3 | sort | uniq -c | while read line;...

ins@ARTMGA01> ./arc.sh
./arc.sh: syntax error at line 4: `$' unexpected

its still giving me a syntax error

nawk -F, 'NR==FNR{_[$0]=0;next}$1==203{a[$3]++}END{for(i in _){a[i]==""&&a[i]=0;print i" 203s = "a[i]}}' subs.list 0812*.TLG

This way we can only get the stats for combinely for whole month.

I...

#!/bin/sh
set -x

for file in $(ls `date +%y%m%d0010202.TLG`)
echo "FILE: $file"
grep ^203 $file | cut -d, -f3 | sort | uniq -c | while read line; do
cnt=$(echo $line | cut -d" " -f1)...

thanks you testS and where do i put the log file in there.
-rw-r--r-- 1 ins users 203905773 Dec 15 00:00 08121400010202.TLG
-rw-r--r-- 1 ins users 236227823 Dec 16 00:00...

My question was only how do i pull out stats for the whole month.
also it gives the number of 203's only for the subcribers ids which are there in the log file. even if a 203 is not there in the...

this works but how do we pull it for the whole month of february and then the ouput doesntcome for subscriber id's which arenot there thats if a 203 is not in the file it doesnt show for
2 0
144 0...

subscriber id is the list above

ins@ARTMGA01> awk -F, 'NR==FNR{_[$0];next}$1==X && $3 in _{a++}END{print a}' X="203" a.out `date +%y%m%d`00010202.TLG
333868
ins@ARTMGA01>

i get this when i run the above query i am not getting...

should i put this into a subscriber list file

2 144 9 129 16 37 42 45 87 104 53 40 62 63 51 158 18 19 20 21 50 67 82 116 64 100 141 168 170 171 49 84 85 35 34 70 61 69 8 26 27 28 78 79 32 33 10...

i have file which contains data like this every day.i need to pull up a report for counting the 203's in that file for each subscriber id.there are around 200 subscriber id's. all ths Y's which i...