How to ignore white spaces while comparing two files.?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to ignore white spaces while comparing two files.?
# 1  
Old 07-15-2013
How to ignore white spaces while comparing two files.?

Hello Experts,

I am trying to compare two files line by line with below code. I want to ignore the spaces while comparing. Only content should be compared.


Code:
 
hostFile="/etc/hosts"
inputFile="/home/scripts/DR/hosts.eas"
grep -E '^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}' $inputFile > temp1
result=$(grep -vxFf $hostFile temp1)

It is looking for the lines starting with Ip address in the host file like 127.0.0.1

If i give any space in between Ip address and host name it is saying entry is not matching.

Below is the sample entry
Code:
 
10.3.242.177       mugwump mugwump.test.server

# 2  
Old 07-15-2013
Can u give your input file contents.So that it wil be easier to see what exact match you want.
# 3  
Old 07-15-2013
ok

Host File

Code:
 
10.3.242.170 sasquatch sasquatch.test.server
10.3.242.171 nessie nessie.atldc.test.server

Input File

Code:
 
10.3.242.170      sasquatch sasquatch.test.server
10.3.242.171 nessie nessie.atldc.test.server

In input file, you can see there are more space after IP address. So it should ignore that space though content is matching.

I am comparing input file enteries should be matching with the host file enteries. Host file can have more entries also but Input file enteries must be there in the host file. I am ignoring comments with that regular experssion but need to ignore spaces also.
# 4  
Old 07-15-2013
why dont you try using awk? You will get number of examples in the forum to match 2 files using awk.
# 5  
Old 07-15-2013
Try the below code which wil squeeze the space.


Code:
 
grep -E '^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}' $inputFile | tr -s " " > temp1

# 6  
Old 07-15-2013
Two things here am looking at matching a smaller set of input file against a big data file and print the contents of input file that is not part of data file.
I am looking for the strict line match. I am ignoring comments with taht regular expression and now i need to ignore the whitespace in between or after the line.

Code:
grep -vxFf datafile inputfile

is the one liner command which is doing job for me. In Awk , it might required to build the big logic to strictly match the lines and need to see also how much time it is taking in comparing file.

This code is working fine, just want to ignore whitespace also as am doing for ignoring comments.

---------- Post updated at 01:57 AM ---------- Previous update was at 01:44 AM ----------

Thanks Milan for your effort.

Actually your suggestion is trimming the spaces in the input file but I want to ingore any spaces while matching the code.
Code:
 
 grep -vxFf $hostFile temp1

# 7  
Old 07-15-2013
Quote:
Originally Posted by sharsour
is the one liner command which is doing job for me. In Awk , it might required to build the big logic to strictly match the lines and need to see also how much time it is taking in comparing file.

This code is working fine, just want to ignore whitespace also as am doing for ignoring comments.
Below command will store the content of hostfile in array and print those lines of input file which is not there in hostfile.
Code:
 
awk 'NR==FNR{A[$1$2$3]=$0;next}
/^[0-9]/{if(!A[$1$2$3]){print $0}}' hostfile inputfile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

List and Delete Files which are older than 7 days, but have white spaces in file name

I need to list and delete all files in current older which are olderthan 7 days. But my file names have white spaces. Before deleting I want to list all the files, so that I can verify.find . -type f -mtime +7 | xargs ls -l {} But the ls command is the working on the files which have white... (16 Replies)
Discussion started by: karumudi7
16 Replies

2. Shell Programming and Scripting

Replace white spaces of multiple files at once

How to rename multiple files by replacing the white spaces with underscore for ex: 293TrexFH\ \ \ GSM855007RINGB_lhb11_binary.txt 293TrexFH\ \ \ GSM855007RINGB_lhb12_binary.txt 293TrexFH\ \ \ GSM855007RINGB_lhb13_binary.txt 293TrexFH_GSM855007RINGB_lhb11_binary.txt... (1 Reply)
Discussion started by: quincyjones
1 Replies

3. Shell Programming and Scripting

Leading white spaces

Hi, I am having problem in deleting the leading spaces:- cat x.csv baseball,NULL,8798765,Most played baseball,NULL,8928192,Most played baseball,NULL,5678945,Most played cricket,NOTNULL,125782,Usually played cricket,NOTNULL,678921,Usually played $ nawk 'BEGIN{FS=","}!a... (2 Replies)
Discussion started by: scripter12
2 Replies

4. UNIX for Dummies Questions & Answers

VIM add white spaces

Hello, How do I adda two whitespaces at the begining of each lines between line 12 and line 90; something like :12,90 ??? Thanks! (3 Replies)
Discussion started by: JCR
3 Replies

5. Shell Programming and Scripting

ksh: removing all white spaces

'String' file contains the following contents, D11, D31, D92, D29, D24, using ksh, I want to remove all white spaces between characters no matter how long the string is. Would you please give me some help? (1 Reply)
Discussion started by: yoonius
1 Replies

6. Shell Programming and Scripting

Two or more white spaces in string

Hi, Can anybody suggest me how to combine two strings with two or more white spaces and assign it to a variable? E.g. first=HAI second=HELLO third="$first $second" # appending strings with more than one white spaces echo $third this would print HAI HELLO Output appears... (2 Replies)
Discussion started by: harish_oty
2 Replies

7. Shell Programming and Scripting

trimming white spaces

I have a variable that calls in a string from txt file. Problem is the string comes with an abundance of white spaces trailing it. Is there any easy way to trim the tailing white spaces off at the end? Thanks in advance. (9 Replies)
Discussion started by: briskbaby
9 Replies

8. Shell Programming and Scripting

Trim white spaces using awk

Hi, I have a CSV file with footer information as below. The third value is the number of records in the file. Sometimes it contains both leading and trailing white spaces which i want to trim using awk. C,FOOTER , 00000642 C,FOOTER , 00000707 C, FOOTER,... (2 Replies)
Discussion started by: mona
2 Replies

9. Shell Programming and Scripting

delete white spaces

hi all... i have the next question: i have a flat file with a lot of records (lines). Each record has 10 fields, which are separated by pipe (|). My problem is what sometimes, in the first record, there are white spaces (no values, nothing) in the beginning of the record, like this: ws ws... (2 Replies)
Discussion started by: DebianJ
2 Replies

10. UNIX for Dummies Questions & Answers

deleting white spaces

How would I delete white spaces in a specified file? Also, I'd like to know what command I would use to take something off a regular expression, and put it onto another. ie. . . . expression1 <take_off> . . . expression2 (put here) . . . Any help would be great, thanks! (10 Replies)
Discussion started by: cary530
10 Replies
Login or Register to Ask a Question