Hi Experts,
i would like to get your help to do some development to the below linux commands which i run under .cmd file in windows
@echo off
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999901"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999914"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999955"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999956"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999902"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999936"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999938"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999927"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999954"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999980"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999981"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999903"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999904"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999923"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999977"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999978"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999911"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "9647802999979"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe "NULL"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\grep.exe -v "96478029999"|f:\linuxutils\grep.exe -v "NULL"|f:\linuxutils\wc.exe -l
call f:\linuxutils\grep.exe "T11" f:\blocked_ranges\dump3.txt|f:\linuxutils\grep.exe ",9647800"|f:\linuxutils\wc.exe -l
echo -------------------------------------------------------------------------------------
the result for the above is just numbers for the counts it does, i want to:
1- add a string before the number, like x value
2- I want the out put to be directed to one single txt to excel file which is better for me, as i prefer excel for reporting
Thanks in advance.