Check 2 files ???


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Check 2 files ???
# 1  
Old 02-15-2006
Check 2 files ???

Hi all,

I know how to count lines, count byte of a file, but really dont know how to compare line , I am newbie and hope you can help me to learn more about UNIX.
Here is my problem.
====
How :

1. File A (Flatfile with NAME|DATE|ID1|ID2|ID3|ID4|ID5)
CJKA|2005-12-10-08.01.30.000000|1111111111|ECI|1112221111|1113331111|1114441111
DMCH|2005-12-10-08.28.00.000000|1111113333|CCCOSSR|1112223333|1113333333|1114443333
DLMQ|2005-12-11-01.00.00.000000|1111117777|STLITE|1112227777|1113337777|1114447777
DMCH|2005-12-10-08.20.00.000000|1111114444|MTRRD|1112224444|1113334444|1114444444
CJKA|2005-12-10-08.10.00.000000|1111112222|OMCRTVI|1112222222|1113332222|1114442222
R1L7|2005-12-10-08.11.00.000000|1111115555|CLAIMS|1112225555||
DLMQ|2005-12-10-08.00.00.000000|1111116666|QAS1|1112226666|1113336666|1114446666
DLMQ|2005-12-11-01.10.00.000000|1111118888|SVCPLN|1112228888|1113338888|1114448888
CJKA|2005-12-10-08.13.30.000000|1111119999|OMCRTVI|1112229999|1113339999|1114449999

2. File B ( 4 lines)
records='9'
bytes='724'
CJKA|2005-12-10-08.01.30.000000|1111111111|ECI|1112221111|1113331111|1114441111
CJKA|2005-12-10-08.13.30.000000|1111119999|OMCRTVI|1112229999|1113339999|1114449999

How we write a ksh script to compare and give another output file

1. a. Check record count in file A is equal 9 in file B.
b. Check byte count in file A is equal line 2 file B 724
c. First record in File A is line 4 in file B
d. last record in file A is line 4 in File B

If it did not match then give the error do not match . Which one is not match

2. If it is match then give the out put
File C name is yyyymmdd.dat in 2nd field of file A , like 20051210.dat , it will be a flatfile
NAME|DATE||||ID4|ID3
====

Thanks for sharing your knowledge .
# 2  
Old 02-15-2006
look at man:

join
sort
uniq
# 3  
Old 02-15-2006
I really dont see sort, uniq in here Smilie

Here is what I did for 1c and 1d
====

$AFIRST=(head -1 A)
$BTHREE=(cat B | sed -n 3p)
if [[ $AFIRST = $BTHREE ]];
then
print "they match"
else
print "they don't match"
fi


ALAST=$(tail -1 A)
BFOUR=$(cat B | sed -n 4p)
if [[ $ALAST = $BFOUR ]]
then
print "they match"
else
print "they don't match"
fi
=======

I got this part for 1a and 1b
ALINES=$(cat A | wc -l)
BFIRST=$(head -1 B)

how do you compare ALINE=9 and BFRIST=records'9' ; how to have only 9 = 9 Smilie
# 4  
Old 02-15-2006
i guess i'm kinda lost in what you're trying to do. bigearsbilly's sugestion of using uniq as an option actually sounds like a pretty good suggestion to me.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to get CRC check sum of files in java EAR file without extracting .jar/.war files to disk.?

unzip -v gives CRC info of each file in a zip(in my case .EAR) file. # unzip -v my-application.ear Archive: my-application.ear Length Method Size Cmpr Date Time CRC-32 Name -------- ------ ------- ---- ---------- ----- -------- ---- 197981 Defl:N 183708 7%... (1 Reply)
Discussion started by: kchinnam
1 Replies

2. Shell Programming and Scripting

Check files and archive the files using sftp

Hi, I have to check the files in another server using sftp to do that, below is the code i am going with #!/bin/bash export SRC_FOLDER=$1 export ARC_FOLDER=$2 HOST=as07u3456 USER=relfag sftp ${USER}@${HOST} <<EOF cd $SRC_FOLDER/DSCOR ls bye EOF echo "done" whatever the files i... (8 Replies)
Discussion started by: ursrami
8 Replies

3. Shell Programming and Scripting

Check for data between two files

I have two files File1.txt 000199458 000199463 000200442 000200831 000200866 000201009 000201050 000201405 000201666 000201682 File2.txt (4 Replies)
Discussion started by: halfafringe
4 Replies

4. Shell Programming and Scripting

Kindly check it: Camparison of files only column1 of 2 files

Hi all, I have 2 files in which i have to find commom entries in column 1 an dif soemthing is common write other data of both files in front of it mentioned. Gene symbol and disease name column 1 column2 ARFGEF2 CAD DDEF2 CAD PSCD3 CAD PSCD4 CAD CAMK1... (15 Replies)
Discussion started by: manigrover
15 Replies

5. Shell Programming and Scripting

Perl code to check date and check files in particular dir

Hi Experts, I am checking how to get day in Perl. If it is “Monday” I need to process…below is the pseudo code. Can you please prove the code for below condition. if (today=="Monday" ) { while (current_time LESS THAN 9:01 AM) ... (1 Reply)
Discussion started by: ajaypatil_am
1 Replies

6. Shell Programming and Scripting

need a shell script to extract the files from source file and check whether those files existonserve

Hi, I am new to shell scripting.Please help me on this.I am using solaris 10 OS and shell i am using is # echo $0 -sh My requirement is i have source file say makefile.I need to extract files with extensions (.c |.cxx |.h |.hxx |.sc) from the makefile.after doing so i need to check whether... (13 Replies)
Discussion started by: muraliinfy04
13 Replies

7. Shell Programming and Scripting

how to check files

Hi, I have a dir in which I need to check for 3 files. and naming for three files are as below. fileone_yyyy_mm_dd.dat filetwo_yyyy_mm_dd.dat filethree_yyyy_mm_dd.datand YYYY_mm_dd will change everyday as the date changes. I need to check everyday all these files are existing or not... (4 Replies)
Discussion started by: ravinunna
4 Replies

8. Shell Programming and Scripting

How to check files and move the results to differents files?

Hi, I am a newbie to shell scripting. here is my objective: 1)The shell program should take 2 parameters - ie-> DestinationFolder, WebFolder 2)Destination folder contains few files that has to has be verified and deleted. 3)WebFolder is a folder containing a list of master files 4)It... (1 Reply)
Discussion started by: sandhyagupta
1 Replies

9. Shell Programming and Scripting

check whether 3 files are present

I'm trying to check whether 3 files are existing and send 3 files as attachements. If only two are there then send those two files as attachments. if ; then elif ; then I tired the above given syntax and then it is giving me an error line 11: ' I tried with -a instead of && and... (3 Replies)
Discussion started by: Celvin VK
3 Replies

10. Solaris

How to check no. of files open currently

I'm getting an error "too many files open" # ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 8192 coredump(blocks) unlimited nofiles(descriptors) 256 memory(kbytes) unlimited # hard limit shows 1024 I would like to know how many files... (1 Reply)
Discussion started by: max_min
1 Replies
Login or Register to Ask a Question