Sponsored Content
Top Forums Shell Programming and Scripting Update a file using other file Post 302962453 by durden_tyler on Monday 14th of December 2015 10:14:39 PM
Old 12-14-2015
Code:
$ 
$ cat file1
S  40149.00  47897.00  11                      453310.8 2443363.8 131.9348000413
S  40573.00  47897.00  11                      453312.3 2448664.5 131.4348000422
S  40147.00  47897.00  11                      453311.9 2443338.5 132.2348000450
S  40575.00  47897.00  11                      453311.9 2448687.9 131.2348000458
S  40145.00  47897.00  11                      453312.7 2443313.0 131.9348000526
$ 
$ cat file2
S  40149.00  47897.00  1V1     0.0   0     0.0 453312.5 2443362.5   0.0348000414
S  40147.00  47897.00  1V1     0.0   0     0.0 453312.5 2443337.5   0.0348000451
S  40145.00  47897.00  1V1     0.0   0     0.0 453312.5 2443312.5   0.0348000527
S  40573.00  47897.00  1V1     0.0   0     0.0 453312.5 2448662.5   0.0348000423
S  40575.00  47897.00  1V1     0.0   0     0.0 453312.5 2448687.5   0.0348000459
$ 
$ perl -F'/\s+/' -lane '$ARGV eq "file1"
                        ? $x{join("|",@F[1,2])} = substr($_,47)
                        : do {$k = join("|",@F[1,2]); substr($_,47) = $x{$k} if defined $x{$k}; print}
                       ' file1 file2
S  40149.00  47897.00  1V1     0.0   0     0.0 453310.8 2443363.8 131.9348000413
S  40147.00  47897.00  1V1     0.0   0     0.0 453311.9 2443338.5 132.2348000450
S  40145.00  47897.00  1V1     0.0   0     0.0 453312.7 2443313.0 131.9348000526
S  40573.00  47897.00  1V1     0.0   0     0.0 453312.3 2448664.5 131.4348000422
S  40575.00  47897.00  1V1     0.0   0     0.0 453311.9 2448687.9 131.2348000458
$ 
$

These 2 Users Gave Thanks to durden_tyler For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

file update

how to update file in unix ? (8 Replies)
Discussion started by: piyush_movadiya
8 Replies

2. Shell Programming and Scripting

update a file with values from other file in shell bash

Hello I need to write a shell script to update properties between files. I have 2 files as follow: file1 urlWebserviceCheckAddress^=McoConfigGlobal.commonGLOBALUrlWebservice file 2 urlWebserviceCheckAddress=http://localhost:8080/tags Both files containt the same properties... (1 Reply)
Discussion started by: teodora
1 Replies

3. Shell Programming and Scripting

how to update a file

-Hi, I have several hundred files, which contain the following pattern: /bb/bin/msga/mm 80& I need to change the above pattern to be /bb/bin/mm 80& I there the command I can use to do that. Thanks a lot (3 Replies)
Discussion started by: aoussenko
3 Replies

4. Shell Programming and Scripting

rsync - update file on backup when file renamed on source

hi all, Please help me with rsync. I configured rsync to preserve timestamps using the -a option. When i renamed fileA to fileB on source machine I have to copies at the backup server. The aim is to keep the most recent file. fileA & fileB has same contents. When i renamed fileB to... (2 Replies)
Discussion started by: coolatt
2 Replies

5. Shell Programming and Scripting

File Update

looking for an Update file command in Unix File A|B|C|D|NAMND|B A|B|C|DD|N|B A|B|C|DD|AAM|L new file should be A|B|C|D|N|B A|B|C|DD|N|B A|B|C|DD|A|L awk -F"|" 'length($5)>1' ----all these records to be updated with 5th filed first charecter (1 Reply)
Discussion started by: userraone
1 Replies

6. Shell Programming and Scripting

Update a file with other file data

Gents, Can you help please. Using information from file1, I will like to update file2. file1 X 2922 1581L 30535.00 51881.001 1 3241 30540.00 51666.00 52312.001 X 2922 8931L 30961.00 52625.001 1 4321 30540.00 52194.00 53056.001 X 2922 1711L 30529.00 ... (2 Replies)
Discussion started by: jiam912
2 Replies

7. Shell Programming and Scripting

Perl to update field in file based of match to another file

In the perl below I am trying to set/update the value of $14 (last field) in file2, using the matching NM_ in $12 or $9 in file2 with the NM_ in $2 of file1. The lengths of $9 and $12 can be variable but what is consistent is the start pattern will always be NM_ and the end pattern is always ;... (4 Replies)
Discussion started by: cmccabe
4 Replies

8. Shell Programming and Scripting

awk to update file with sum of matching fields in another file

In the awk below I am trying to add a penalty to a score to each matching $1 in file2 based on the sum of $3+$4 (variable TL) from file1. Then the $4 value in file1 is divided by TL and multiplied by 100 (this valvue is variable S). Finally, $2 in file2 - S gives the updated $2 result in file2.... (2 Replies)
Discussion started by: cmccabe
2 Replies

9. Shell Programming and Scripting

Move file from one directory and update the list file once moved.

Dears, I have a listfile contains list of files path. i need to read the line of the listfile mv the file to other directory and update the listfile by deleting the lines of the listfile. #!/bin/bash target=/fstest/INVESTIG/Sadiq/TEST_ARCH while read -r line || ]; do mv $line... (19 Replies)
Discussion started by: sadique.manzar
19 Replies

10. UNIX for Beginners Questions & Answers

awk to update file with partial matching line in another file and append text

In the awk below I am trying to cp and paste each matching line in f2 to $3 in f1 if $2 of f1 is in the line in f2 somewhere. There will always be a match (usually more then 1) and my actual data is much larger (several hundreds of lines) in both f1 and f2. When the line in f2 is pasted to $3 in... (4 Replies)
Discussion started by: cmccabe
4 Replies
DIFF(1) 						      General Commands Manual							   DIFF(1)

NAME
diff - differential file comparator SYNOPSIS
diff [ -efbh ] file1 file2 DESCRIPTION
Diff tells what lines must be changed in two files to bring them into agreement. If file1 (file2) is `-', the standard input is used. If file1 (file2) is a directory, then a file in that directory whose file-name is the same as the file-name of file2 (file1) is used. The normal output contains lines of these forms: n1 a n3,n4 n1,n2 d n3 n1,n2 c n3,n4 These lines resemble ed commands to convert file1 into file2. The numbers after the letters pertain to file2. In fact, by exchanging `a' for `d' and reading backward one may ascertain equally how to convert file2 into file1. As in ed, identical pairs where n1 = n2 or n3 = n4 are abbreviated as a single number. Following each of these lines come all the lines that are affected in the first file flagged by `<', then all the lines that are affected in the second file flagged by `>'. The -b option causes trailing blanks (spaces and tabs) to be ignored and other strings of blanks to compare equal. The -e option produces a script of a, c and d commands for the editor ed, which will recreate file2 from file1. The -f option produces a similar script, not useful with ed, in the opposite order. In connection with -e, the following shell program may help maintain multiple versions of a file. Only an ancestral file ($1) and a chain of version-to-version ed scripts ($2,$3,...) made by diff need be on hand. A `latest version' appears on the standard output. (shift; cat $*; echo '1,$p') | ed - $1 Except in rare circumstances, diff finds a smallest sufficient set of file differences. Option -h does a fast, half-hearted job. It works only when changed stretches are short and well separated, but does work on files of unlimited length. Options -e and -f are unavailable with -h. FILES
/tmp/d????? /usr/lib/diffh for -h SEE ALSO
cmp(1), comm(1), ed(1) DIAGNOSTICS
Exit status is 0 for no differences, 1 for some, 2 for trouble. BUGS
Editing scripts produced under the -e or -f option are naive about creating lines consisting of a single `.'. DIFF(1)
All times are GMT -4. The time now is 01:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy