Comparing Data file with Crtl file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Comparing Data file with Crtl file
# 15  
Old 04-18-2013
Try making a test case to get this part working:
Code:
$ cat test.txt
file_1|process_1|cnt_1
file_2|process_2|cnt_2

Code:
$ cat test.sh
#!/bin/bash
IFS='|'
while read fname Process_dt rec_cnt; do
  echo "$fname, $Process_dt, $rec_cnt "
  echo "Checking if the File exist in the folder..."
  if [ -f $fname ]; then
    echo "$fname Exist"
  else
    echo "$fname Does not Exist"
  fi
done < test.txt

Code:
$ ls file_?
file_1

Code:
$ ./test.sh
file_1, process_1, cnt_1
Checking if the File exist in the folder...
file_1 Exist
file_2, process_2, cnt_2
Checking if the File exist in the folder...
file_2 Does not Exist

This User Gave Thanks to hanson44 For This Post:
# 16  
Old 04-23-2013
I have 2 data files and 2 crtl files.
Say-
A.txt B.txt
C.crtl D.crtl
crtl file has filename|processdate|recordcount
the data in crtl files must be compared with all the txt files
and it should validated
I wrote code which works for 1 txt and 1 crtl, I dont know
how to write for 2 crtl files and multiple txt files.
# 17  
Old 04-23-2013
I'm afraid I'm a little unclear what the additional requirement is. What if you start a new topic, with a different title, maybe a title like "Comparing Multiple Data files with Ctrl files", because it's a little different, and post the information in code tags? In other words, make two sample control files, a few text files, the best shot at the current script you are using, and what output you are expecting. It can get confusing once a thread has gone on for a while, and we want everyone in a good mood. Smilie
# 18  
Old 04-23-2013
sorry I just gone out of mind Smilie
that was a different topic and I posted it wrongly, thanks for your concern and you have helped me in framing out the code. SmilieSmilie

just one more help hanson44 -

how to concat two .crtl files and to write in separate .crtl file ?
can you help me with the syntax ?

file A
abcd
efgh

file B

ijkl
mnop

output must be -

file C
abcd
efgh
ijkl
mnop
# 19  
Old 04-23-2013
The best way is:
Code:
cat fileA fileB > fileC

This User Gave Thanks to hanson44 For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Comparing 2 column of a file with the lines in another file

Hi I have 2 files which are tab delimited. file1 chr1 5 10 P1 KR4 chr1 10 20 1H LA1 R0 TA1 file2 P1 G6 13.27 0.2425 P1 KR4 18.79 0.3060 P1 DND1 19.44 0.2833 N1 DH1 0.99 1.08 1H R0 0.9 NA LA1 R0 90 0.9 TA1 KR4 1.8 8.9 TA1 R0 9.7 99I want to check whether first 2 columns in file2 (column... (1 Reply)
Discussion started by: raj_k
1 Replies

2. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

3. Shell Programming and Scripting

Script for Comparing directories and file from a text file

Hello all, I need to write a script which has following requirement: Need to read the filenames from text file and then search for the above read files in the required directory and if match found backup them in a backup folder. And also need to compare and verify whether the files in the... (7 Replies)
Discussion started by: saurau
7 Replies

4. Shell Programming and Scripting

Retrieve data from one file comparing the ID in the second file

Hi all, I have one file with IDs Q8NDM7 P0C1S8 Q8TF30 Q9BRP8 O00258 Q6AWC2 Q9ULE0 Q702N8 A4UGR9 Q13426 Q6P2D8 Q9ULM3 A8MXQ7 I want to compare ID file with another file which has complete information about these IDs and also about other IDs which are not in the above ID file. As... (10 Replies)
Discussion started by: kaav06
10 Replies

5. UNIX for Dummies Questions & Answers

Mapping a data in a file and delete line in source file if data does not exist.

Hi Guys, Please help me with my problem here: I have a source file: 1212 23232 343434 ASAS1 4 3212 23232 343434 ASAS2 4 3234 23232 343434 QWQW1 4 1134 23232 343434 QWQW2 4 3212 23232 343434 QWQW3 4 and a mapping... (4 Replies)
Discussion started by: kokoro
4 Replies

6. Shell Programming and Scripting

Remove duplicate lines from first file comparing second file

Hi, I have two files with below data:: file1:- 123|aaa|ppp 445|fff|yyy 999|ttt|jjj 555|hhh|hhh file2:- 445|fff|yyy 555|hhh|hhh The records present in file1, not present in file 2 should be writtent to the out put file. output:- 123|aaa|ppp 999|ttt|jjj Is there any one line... (3 Replies)
Discussion started by: gani_85
3 Replies

7. Shell Programming and Scripting

Comparing rows in same file and writing the result in new file

Help needed... Can you tell me how to compare the last two couple entries in a file and print their result in new file..:confused: I have one file Check1.txt \abc1 12345 \abc2 12327 \abc1 12345 \abc2 12330 I want to compare the entries in Check1 and write to... (1 Reply)
Discussion started by: kichu
1 Replies

8. Shell Programming and Scripting

Need help in comparing a file with log file: perl code

Dear Members, I need a perl code: 1. Which will open first file with two columns separated by tab: 37 Distribution and seasonal variation of trace metals 85 Seasonal variability of the mixed layer in the central Bay 99 Dynamics of transparent exopolymeric particles (TEP) 103 Bacterial... (0 Replies)
Discussion started by: srsahu75
0 Replies

9. Shell Programming and Scripting

Comparing data inside file

Hi Everyone, I will try to explain my question please forgive my english here. I am looking for shell script or command that can compare data in the files. I have 50 files in one directory test1 test2 test3 ....so on. I want to compare data in each files with each other and output each... (4 Replies)
Discussion started by: email-lalit
4 Replies

10. Shell Programming and Scripting

Comparing data in file with values in table

Hi, I want to calculate the number of pipe delimiters in a file for all lines seperately. For eg:i have a file Project.txt Mohit|chawla|123|678 File1|File2|345|767|678 And my file contains many lines like this it shd give me the output as 4 5 or give me the output for all the... (0 Replies)
Discussion started by: Mohit623
0 Replies
Login or Register to Ask a Question