Sponsored Content
Top Forums Shell Programming and Scripting Update a file using other file Post 302962433 by jiam912 on Monday 14th of December 2015 03:32:23 PM
Old 12-14-2015
Update a file using other file

Gents,

Please help.
Matching fields 2 and 3 in file1 and file2, I will like to update the file 2 using the information (column 48 to 71) from file 1

examples

file1
Code:
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

File2
Code:
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

output
Code:
S  40149.00  47897.00  1V1     0.0   0     0.0 453310.8 2443363.8 131.9348000414                               
S  40147.00  47897.00  1V1     0.0   0     0.0 453311.9 2443338.5 132.2348000451                               
S  40145.00  47897.00  1V1     0.0   0     0.0 453312.7 2443313.0 131.9348000527                               
S  40573.00  47897.00  1V1     0.0   0     0.0 453312.3 2448664.5 131.4348000423                               
S  40575.00  47897.00  1V1     0.0   0     0.0 453311.9 2448687.9 131.2348000459

Thanks for your help.
 

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
set_color(1)                                                           fish                                                           set_color(1)

NAME
set_color - set_color - set the terminal color set_color - set the terminal color Synopsis set_color [-v --version] [-h --help] [-b --background COLOR] [COLOR] Description Change the foreground and/or background color of the terminal. COLOR is one of black, red, green, brown, yellow, blue, magenta, purple, cyan, white and normal. o -b, --background Set the background color o -c, --print-colors Prints a list of all valid color names o -h, --help Display help message and exit o -o, --bold Set bold or extra bright mode o -u, --underline Set underlined mode o -v, --version Display version and exit Calling set_color normal will set the terminal color to whatever is the default color of the terminal. Some terminals use the --bold escape sequence to switch to a brighter color set. On such terminals, set_color white will result in a grey font color, while set_color --bold white will result in a white font color. Not all terminal emulators support all these features. This is not a bug in set_color but a missing feature in the terminal emulator. set_color uses the terminfo database to look up how to change terminal colors on whatever terminal is in use. Some systems have old and incomplete terminfo databases, and may lack color information for terminals that support it. Download and install the latest version of ncurses and recompile fish against it in order to fix this issue. Version 1.23.1 Sun Jan 8 2012 set_color(1)
All times are GMT -4. The time now is 07:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy