Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Comparing Data file with Crtl file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Comparing Data file with Crtl file
# 8  
Old 04-18-2013
Quote:
but should we use ; in IF statements...??
If I'm interpreting your question correctly, this is perfectly correct:
Code:
if [ $x -eq 1 ]; then

So is this:
Code:
if [ $x -eq 1 ]
  then

# 9  
Old 04-18-2013
Thanks a lot hanson44

I understood and it worked Smilie

but the console is not going inside the while loop
Code:
while IFS='|' && read fname Process_dt rec_cnt
do 
set of statements
done < POR.crtl

it has to print filename procdate and record count but none is executing..!
is ter any problem in while statement ?
# 10  
Old 04-18-2013
Lose the "&&" operator
Code:
while IFS='|' read fname Process_dt rec_cnt

# 11  
Old 04-18-2013
Would this work? Don't you just need to set IFS once?
Code:
IFS='|'
while read fname Process_dt rec_cnt
  do 
  set of statements
done < POR.crtl

# 12  
Old 04-18-2013
If we remove the '&&' operator and suppose the crtl file has details of more than one data file will this code work?
I tried giving IFS outside while loop still the while statement not executing...!

Code:
IFS='|'
while read fname Process_dt rec_cnt
do
echo "\n $fname $Process_dt $rec_cnt "
echo "\n Checking if the File exist in the folder..."
if  [-f $fname]
then
echo "\n $fname Exist"
else
echo "\n $fname Does not Exist"
fi
done < POR.crtl

# 13  
Old 04-18-2013
Try this. Note especially if [ -f $fname ] instead of if [-f $fname]
Code:
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 < POR.crtl

# 14  
Old 04-18-2013
I have tried all possible but the console doesnt goes into the while loop itself only if it goes it will check for file existence and it prints relevant message.
I m not sure whether I have missed something in while loop. Placed IFS outside while but still problem persists. Do we have any other statements that we can instead of while ??
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