here we should take only $2 for comparison. As you can most of the $2 field records has value and some do not have value
Question:
I want to take the fields $5 , $6 , $7 from file 1 and compare it with $2 field from file 2. and the rsult should be like this
Code:
if $5 (file1) =$2 (file2) then replace $5 (file1) with $1 of (file2)
if $6 (file1) =$2 (file2) then replace $6 (file1) with $1 of (file2)
if $7 (file1) =$2 (file2) then replace $7 (file1) with $1 of (file2)
awk -F\| 'NR == FNR { # while reading the first non-empty input file
map[$2] = $1 # build an associative array named map indexed by $2, $1 as values
next # skip the rest of the program
}
{
for (i = 4; ++i <=7;) { # while reading the rest of the input, for each field from 5 to 7
sub(/ *$/, x, $i) # trim any trailing spaces
$i in map && $i = map[$i] # if the column value is an index in the map array, set its value to map[$i]
}
}
42 # print the (modified) records
' OFS=\| file2.txt file1.txt
Each awk statement consists of a pattern with an associated action,
either the pattern or the action can be omitted, but not both.
Code:
pattern { action }
In this case - 42 - we have a single expression.
It matches when its value is nonzero (if a number) or non-null (if a string).
Basically, it could be any number different than 0 or any string different than "".
As far as the choice of 42 is concerned, see this.
I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ?
Source File
*************
# file: /local/test_1
# owner: own
#... (4 Replies)
I hope I can explain this correctly. I am using Bash-4.2 for my shell.
I have a group of file names held in an array. I want to compare the names in this array against the names of files currently present in a directory. If the file does not exist in the directory, that is not a problem.... (5 Replies)
Hi Friends,
I have file1.txt
file2.txt
I tried using the diff and comm but not getting the expected output..
I want where exactly the miss match occurs. probably the field.
Sourcevalue|Targetvalue|Linenumber|field
29123975|2923975|3|1
Please help. (6 Replies)
Hi Guys ,
we have one directory ...in that directory all files will be set on each day..
files must have header ,contents ,footer..
i wants to compare the header,contents,footer ..if its same means display an error message as 'files contents same' (7 Replies)
I've two files with data like below:
file1.txt:
AAA,Apples,123
BBB,Bananas,124
CCC,Carrot,125
file2.txt:
Store1|AAA|123|11
Store2|BBB|124|23
Store3|CCC|125|57
Store4|DDD|126|38
So,the field separator in file1.txt is a comma and in file2.txt,it is |
Now,the output should be... (2 Replies)
I really need help on creating a script that does the following:
I have one file (File 1) with lines in the following format:
Name.maf score1 score2
I have a second file (File 2) with lines in the following format:
label start end Name
What I need to do is compare File 1 and... (1 Reply)
I have a file called X, which contains the following:
10
100
200
300
I then have file Y, which containts the following:
10
200
500
800
I want to write a script that will compare the contents of Y with the contents of X and ONLY return values in Y that does not exist in X (output... (5 Replies)
Hi
I need to compare shadow file sizes with their real file counterparts. If the shadow file size differs form the realfile size then it must send a mail. My problem is that our system has over 1600 shadowfiles in different directories, with different names. the only consistancy is the .sh file... (4 Replies)
05-10-2011
.