Search Results

Hi,

Need to extract a file containing multiple .txt files without using tar/unzip as they are not available

Hi Don,

I need 4 different counts with their match for exact values as :
YES : ~Y or YES~
No : ~N or NO~
No Response : ~No Response~
Junk : Other than above 3

The line
print "YES : $(cat count.xls|grep -i '~Y or YES~' | wc -l)">>final_count.xls

is working correctly for me as i have data delimited by ~ and I am looking for occurances of field Y or YES.

Hi Don,

Below is the code :


while read LINE
do
cat ${LINE}>>count.xls
done < file.txt
print "Total Records : $(awk -F'~' '($1=="99") { sum+=$2 } END { print sum+0 }'...

Hi Don,

I don't have exact code here with me but i can tell you the process

1. I did merge of all the files using cat
2. then found total count using awk on merged file and put all results...

Hi rbatte 1,

Actually i am new to this. It would be great if you suggest me process doc's/threads from past. I need to understand the process and then I will implement this.

I have few ...

Thanks Buddy.

can I store this output of awk to other file?

---------- Post updated 09-13-14 at 12:50 AM ---------- Previous update was 09-12-14 at 08:06 AM ----------

I have achieved the...

Will it work if s= `awk '{gsub(/\..*/,X,$0);print "result= " $0}'` ?

I have some commands which are used to find filenames, counts, previous day files and currently i am running them in directories to get results. Is it possible to call them from excel?

How to run scripts from Excel and bring results back to excel?

Thanks
Can we check for 99~ and then will sum up the value on right?
How can I store this Output of awk command to any other file?

---------- Post updated at 08:28 AM ---------- Previous update...

I have a file with data merged from multiple files. File contains header, data and trailer of multiple files. The trailer starts with 99 and delimiter is ~.
Trailer
99~120
99~30
As it is a...

what will be the scripts if we go for merging files and then counting individual count?
I need output in below format
Total Records : 263
YES : 143
NO : 8
No Response : 102

Thanks dear,

Actually efficiency will not be considered in this case as filename.txt will have maximum 10 record(file names).

Can you please tell me if second loop can find YES / No as addition...

Thanks Chubler_XL,
Can i call two different loops inside one ksh script one for total count and other for YES /No?

I have list of file names in filename.txt
below is file format
>>File1
_________________________
01~12345~Y~YES~aaaaa~can
02~23456~N~NO~bbbbb~can
.
.
.
99~23__________________________
...