|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk to update value in field based on another field
Post 302986915 by RavinderSingh13 on Thursday 1st of December 2016 02:30:32 PM
12-01-2016
Moderator
This User Gave Thanks to RavinderSingh13 For This Post:
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
So, I need to do some summing. I have an Apache log file with the following as a typical line:
127.0.0.1 - frank "GET /apache_pb.gif HTTP/1.0" 200 2326
Now, what I'd like to do is a per-minute sum. So, I can have awk tell me the individual minutes, preserving the dates(since this is a... (7 Replies)
Discussion started by: treesloth
7 Replies
2. Shell Programming and Scripting
Hi
i am new to scripting. i have a file file.dat with content as :
CONTENT_STORAGE PERCENTAGE FLAG:
/storage_01 64% 0
/storage_02 17% 1
I need to update the value of FLAG for a particular CONTENT_STORAGE value
I have written the following code
#!/bin/sh
threshold=20... (1 Reply)
Discussion started by: kichu
1 Replies
3. Shell Programming and Scripting
If $1 in file1 matches $2 in file2. Then the value in $2 of file2 is updated to $1"."$2 of file2. The awk seems to only match the two files but not update. Thank you :).
awk
awk 'NR==FNR{A ; next} $1 in A { $2 = a }1' file1 file2
file1
name version
NM_000593 5
NM_001257406... (3 Replies)
Discussion started by: cmccabe
3 Replies
4. Shell Programming and Scripting
I am trying to use awk to match two files that are tab-delimited. When a match is found between file1 $1 and file2 $4, $4 in file2 is updated using the $2 value in file1. If no match is found then the next line is processed. Thank you :).
file1
uc001bwr.3 ADC
uc001bws.3 ADC... (4 Replies)
Discussion started by: cmccabe
4 Replies
5. Shell Programming and Scripting
I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines.
If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
Discussion started by: cmccabe
3 Replies
6. Shell Programming and Scripting
In the awk below I am trying to set/update the value of $14 in file2 in
bold, 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 ;... (2 Replies)
Discussion started by: cmccabe
2 Replies
7. Shell Programming and Scripting
In the perl below, which does execute, I am having trouble with the else in Rule 3. The digit in f{8} is extracted and used to update f accordinly along with the value in f.
There can be either - * or + before the number that is extracted but the same logic applies, that is if the value is greater... (5 Replies)
Discussion started by: cmccabe
5 Replies
8. Shell Programming and Scripting
I have been reading old posts and trying to come up with a solution for the below: Use a tab-delimited input file to assign
point to variables that are used to update a specific field, Rank. I really couldn't find too much in the way of assigning points
to variable, but made an attempt at an awk... (4 Replies)
Discussion started by: cmccabe
4 Replies
9. Shell Programming and Scripting
I have an input file with
A=xyz
B=pqr
I would want the value in Second Field (xyz or pqr) updated with a value present in Shell Variable based on the value passed in the first field. (A or B )
while read line
do
NEW_VALUE = `some functionality done on $line`
If $line=First Field-... (1 Reply)
Discussion started by: infernalhell
1 Replies
10. UNIX for Beginners Questions & Answers
Hi,
So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple... (15 Replies)
Discussion started by: cotilloe
15 Replies
LEARN ABOUT SUSE
mautil
MAUTIL(1) User Commands MAUTIL(1) NAME
mautil - Mono.Addins Setup Utility SYNOPSIS
mautil [options] <command> [arguments] DESCRIPTION
The mautil tool works with Mono.Addins repositories and packages. OPTIONS
--registry, -reg Specify add-in registry path --path, -p Specify startup path -v Verbose output Add-in commands: install, i Installs add-ins. uninstall, u Uninstalls add-ins. check-install, ci Checks installed add-ins. update, up Updates installed add-ins. list, l Lists installed add-ins. list-av, la Lists add-ins available in registered repositories. list-update, lu Lists available add-in updates. Repository Commands: rep-add, ra Registers repositories. rep-remove, rr Unregisters repositories. rep-update, ru Updates the lists of available addins. rep-list, rl Lists registered repositories. Add-in Registry Commands: reg-update, rgu Updates the add-in registry. reg-build, rgb Rebuilds the add-in registry. info Prints information about an add-in. Packaging Commands: rep-build, rb Creates a repository index file for a directory structure. pack, p Creates a package from an add-in configuration file. help, h Shows help about a command. Debug Commands: dump-file Prints the contents of a registry file. SEE ALSO
mono(1). Mono.Addins May 2008 MAUTIL(1)