Sponsored Content
Top Forums Shell Programming and Scripting awk - testing a field for a previous value Post 302224298 by jmd2004 on Tuesday 12th of August 2008 08:21:03 PM
Old 08-12-2008
awk - testing a field for a previous value

Hi,

Is their anyway to compare the value of a field in one line with the previous line?

I would like to

if previous volume name is the same then subtract the current value of $4 with the previous value of $4


data file

host date volume mb used
----------------------------------------------------
server1 02/01/2008 groups 10mb
server1 03/01/2008 groups 15mb
server1 04/01/2008 groups 20mb
server2 02/01/2008 users 50mb
server2 03/01/2008 users 75mb
server2 04/01/2008 users 100mb
server2 04/01/2008 users 125mb

what i would like the output to look like

host date volume mb used difference
--------------------------------------------------------------
server1 02/01/2008 groups 10mb 0
server1 03/01/2008 groups 15mb 5
server1 04/01/2008 groups 20mb 10
server2 02/01/2008 users 50mb 0
server2 03/01/2008 users 75mb 25
server2 04/01/2008 users 100mb 50
server2 04/01/2008 users 125mb 75

Any help would be greatly appreciated!

Thanks,
JD
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

eAdd two fields in a column if their previous field values are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output file as follows If field3 in file1 is same as field3 in the next line then the field4 should add... (1 Reply)
Discussion started by: yerruhari
1 Replies

2. Shell Programming and Scripting

awk, comma as field separator and text inside double quotes as a field.

Hi, all I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes. sample input: for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies

3. Shell Programming and Scripting

Print a field from the previous line

plz help me!! I have this file , 3408 5600 3796 6035 4200 6285 4676 0 40 1554 200 1998 652 2451 864 2728 1200 0 I want it like if $2==0,replace it with field from the previous line+500 say here the o/p would be like 3408 5600 3796 6035 4200 6285... (16 Replies)
Discussion started by: Indra2011
16 Replies

4. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

5. Shell Programming and Scripting

Compare Field in Current Line with Field in Previous

Hi Guys I have the following file Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above: Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Discussion started by: moutaye
9 Replies

6. Shell Programming and Scripting

awk to parse field and include the text of 1 pipe in field 4

I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close: awk so far: awk '{sub(/\|]+]++/, ""); print }' input.txt Input chr1 955543 955763 AGRN-6|pr=2|gc=75 0 + chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 + chr1 970621 ... (7 Replies)
Discussion started by: cmccabe
7 Replies

7. Shell Programming and Scripting

Extract row grater than 3 from previous value of a field

Hi, I am trying to extract data where first field unique value and 4th field of next row is grater than first row 4th field. input data is a below: 7035719974,20-jul-2016 07:42:51,07:42:51,074251,1 7035719974,20-jul-2016 07:43:57,07:43:57,074357,2 7399206761,20-jul-2016... (2 Replies)
Discussion started by: rramkrishnas
2 Replies

8. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

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

9. Shell Programming and Scripting

awk to update field using matching value in file1 and substring in field in file2

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

10. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

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
VOS_CHANGELOC(1)					       AFS Command Reference						  VOS_CHANGELOC(1)

NAME
vos_changeloc - Change a volume's entry in the VLDB SYNOPSIS
vos changeloc [-server] <new server name> [-partition] <new partition location> [-id] <volume name or ID> [-cell <cell name>] [-noauth] [-localauth] [-verbose] [-encrypt] [-noresolve] [-help] vos changel [-s] <new server name> [-p] <new partition location> [-i] <volume name or ID> [-c <cell name>] [-noa] [-l] [-v] [-e] [-nor] [-h] DESCRIPTION
The vos changeloc command changes the location of a volume in the Volume Location Database (VLDB) without needing to contact the original file server on which the volume was hosted. This is useful when a file server has gone down permanently and the data that was stored on that server has been moved to a new file server with a different name and IP address (perhaps by mounting the same /vicepX partitions on a different host). After moving the data and running vos changeloc, run vos syncvldb and then vos syncserv against the new server to ensure full synchronization of the VLDB with the file server. In essence, vos changeloc performs the same operations on the VLDB as vos move, but it does NOT move the data from one server's file system to another. CAUTIONS
Using vos changeloc changes the VLDB without modifying the file server data, so it inherently causes the VLDB to be out of sync with the data on the servers. It should only be used when recovering from server failure. If the servers are on-line, vos move should be used instead. It is highly recommended that vos syncvldb and vos syncserv be run after using the vos changeloc command to ensure properly synchronization of the VLDB with the file servers. OPTIONS
vos changeloc takes the following options: -server <new server name> Specifies the new server where the VLDB should believe the volume resides. Provide the machine's IP address or its host name (either fully qualified or using an unambiguous abbreviation). For details, see vos(1). -partition <partition name> Specifies the partition where the VLDB should believe the volume resides. Provide the -server argument along with this one. Provide the partition's complete name with preceding slash (for example, "/vicepa") or use one of the three acceptable abbreviated forms. For details, see vos(1). -id <volume name or ID> Specifies the name or volume ID number on which to operate. -cell <cell name> Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see vos(1). -noauth Assigns the unprivileged identity "anonymous" to the issuer. Do not combine this flag with the -localauth flag. For more details, see vos(1). -localauth Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The vos command interpreter presents it to the Volume Server and Volume Location Server during mutual authentication. Do not combine this flag with the -cell argument or -noauth flag. For more details, see vos(1). -verbose Produces on the standard output stream a detailed trace of the command's execution. If this argument is omitted, only warnings and error messages appear. -encrypt Encrypts the command so that the operation's results are not transmitted across the network in clear text. This option is available in OpenAFS versions 1.4.11 or later and 1.5.60 or later. -noresolve Shows all servers as IP addresses instead of the DNS name. This is very useful when the server address is registered as 127.0.0.1 or when dealing with multi-homed servers. This option is available in OpenAFS versions 1.4.8 or later and 1.5.35 or later. -help Prints the online help for this command. All other valid options are ignored. OUTPUT
vos changeloc shows a brief message upon completion: Changed location to server2 /vicepa for volume user.jdoe EXAMPLES
The following command changes the location of the "user.jdoe" volume to be /vicepa on the file server machine "server2" while being verbose: % vos changeloc server2 a user.jdoe -verbose done Changed location to server2 /vicepa for volume user.jdoe The following command changes the location of the "user.jdoe" volume to be /vicepa on "server1" without being verbose: % vos changeloc server1 a user.jdoe Changed location to server1 /vicepa for volume user.jdoe PRIVILEGE REQUIRED
The issuer must be listed in the /etc/openafs/server/UserList file on each database server machine. If the -localauth flag is included, the issuer must instead be logged on to a server machine as the local superuser "root". SEE ALSO
vos(1), vos_move(1), vos_syncserv(1), vos_syncvldb(1) COPYRIGHT
Copyright 2007 Jason Edgecombe <jason@rampaginggeek.com> This documentation is covered by the BSD License as written in the doc/LICENSE file. This man page was written by Jason Edgecombe for OpenAFS. OpenAFS 2012-03-26 VOS_CHANGELOC(1)
All times are GMT -4. The time now is 08:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy