Shell Programming and Scripting

Hi,
I need someone's help in writing a shell script. Since am very new i am stuck .

I have 2 files in the same dir.

==============================================

FileA

Table1~07/07/2009 00:00:00~4
Table1~07/06/2009 00:00:00~41
Table1~07/08/2009 00:00:00~4

Table2~07/08/2009 00:00:00~4

FileB

Table1~07/07/2009 00:00:00~4
Table1~07/06/2009 00:00:00~44
Table1~07/08/2009 00:00:00~4

Table2~07/08/2009 00:00:00~4

============================================

I am looking to take the data from both files in this manner.
Based on the timestamp i need take the rec, i.e if there are 3 days 6,7 & 8 (8 is today's date) then i need to take the rec of yesterday's i.e.7 (sysdate-1 th rec) from both files.

Table1 from both files for date 7 & at the end in file is the count (i.e 41 in fileA & 44 in fileB) are the counts.

I need to find the difference of them (fileB - fileA)
& i need the o/p in this format :

Table1 3 (in a new file)

so steps are :

Grep for recs with sysdate - 1st rec
Take the Tb name & count from both files
Take the difference of fileA & fileB count
Print it in a new file.

If some one can help me out in this, it would be of great help.

I tried like this :

I had 2 files a and b

a :

SVC_REQ_CNT~07/05/2009 00:00:00~16
SVC_REQ_CNT~07/06/2009 00:00:00~10
SVC_REQ_CNT~07/07/2009 00:00:00~18

SVC_ORD_CNT~01/22/2098 00:00:00~2
SVC_ORD_CNT~02/04/2099 00:00:00~2
SVC_ORD_CNT~07/07/2009 00:00:00~1


b :

SVC_REQ_CNT~07/05/2009 00:00:00~16
SVC_REQ_CNT~07/06/2009 00:00:00~10
SVC_REQ_CNT~07/07/2009 00:00:00~19

SVC_ORD_CNT~01/22/2098 00:00:00~2
SVC_ORD_CNT~02/04/2099 00:00:00~2
SVC_ORD_CNT~07/07/2009 00:00:00~5


I tried the following :

grep `TZ=aaa24 date +\%m/%d/%Y` a | cut -d '~' -f 3-4

o/p :

18
1


grep `TZ=aaa24 date +\%m/%d/%Y` b | cut -d '~' -f 3-4

19
5

Now i have to proceed further. Take the diff & put it in a new file along with the tb name ..

Thanks,
Vijay.

what have you tried till now??

You seem to be clear in what you want.. where exactly are you stuck.

I tried like this :

I had 2 files a and b

a :

SVC_REQ_CNT~07/05/2009 00:00:00~16
SVC_REQ_CNT~07/06/2009 00:00:00~10
SVC_REQ_CNT~07/07/2009 00:00:00~18

SVC_ORD_CNT~01/22/2098 00:00:00~2
SVC_ORD_CNT~02/04/2099 00:00:00~2
SVC_ORD_CNT~07/07/2009 00:00:00~1


b :

SVC_REQ_CNT~07/05/2009 00:00:00~16
SVC_REQ_CNT~07/06/2009 00:00:00~10
SVC_REQ_CNT~07/07/2009 00:00:00~19

SVC_ORD_CNT~01/22/2098 00:00:00~2
SVC_ORD_CNT~02/04/2099 00:00:00~2
SVC_ORD_CNT~07/07/2009 00:00:00~5


I tried the following :

grep `TZ=aaa24 date +\%m/%d/%Y` a | cut -d '~' -f 3-4

o/p :

18
1


grep `TZ=aaa24 date +\%m/%d/%Y` b | cut -d '~' -f 3-4

19
5

Now i have to proceed further. Take the diff & put it in a new file along with the tb name ..

Are you cheching the largest value for the count?
Are 18,1 and 19,5 not counts you needed, am confused...

Hello,

Per our forum rules, all threads must have a descriptive subject text. For example, do not post questions with subjects like "Help Me!", "Urgent!!" or "Doubt". Post subjects like "Execution Problems with Cron" or "Help with Backup Shell Script".

The reason for this is that nearly 95% of all visitors to this site come here because they are referred by a search engine. In order for future searches on your post (with answers) to work well, the subject field must be something useful and related to the problem!

In addition, current forum users who are kind enough to answer questions should be able to understand the essence of your query at first glance.

So, as a benefit and courtesy to current and future knowledge seekers, please be careful with your subject text. You might receive a forum infraction if you don't pay attention to this.

Thank you.

The UNIX and Linux Forums

am nor checking for the largest value. I have to take the counts from both files a and b & subtract (b-a) to take the count & place the o/p value in a new file.

i.e. 19-18 = 1
5-1=4

the o/p file shud contain

SVC_REQ_CNT~1
SVC_ORD_CNT~4