Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to ignore white spaces while comparing two files.?

Login to Discuss or Reply to this Discussion in Our Community

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

I tried your command, but it is not going through and even not throwing any error on the console.

One more question,

What I can understand is you are stroing each keyword of a line in $1, $2, $3
In some of the cases, lines will contain 5 words also and in some cases only 3. Will this solution work for it

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

So like this there will be multiple lines.
# 9  
Old 07-15-2013
Quote:
Originally Posted by vidyadhar85
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

There should be $1 FS $2 FS $3 instead of $1$2$3. This is still a bit ugly because the "# fields for comparison" is hard-coded (here: 3).
The following is unlimited:
Code:
awk '/^[^0-9]/ {next} {$1=$1} NR==FNR {A[$0]; next} !($0 in A)' $hostFile temp1

$1=$1 is the trick to reorganize the input line with OFS (single space character).
Last edited by MadeInGermany; 07-15-2013 at 11:23 AM.. Reason: OFS not ORS; added "next" for clarity
This User Gave Thanks to MadeInGermany For This Post:
sharsour
# 10  
Old 07-15-2013
Thanks Made in germany, It worked like anything.

Thanks a lot.
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