Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Create a calculated field from existing fields Post 302114923 by anbu23 on Thursday 19th of April 2007 11:13:53 AM
Old 04-19-2007
Quote:
Originally Posted by atchleykl
I need to add an average field to a file. I can create it in an on-screen report and it does what I need using the awk command but I can't get it to create a new file with the additional field. Here's what I'm working with:

file layout: id:lastname:firstname:grade1:grade2:grade3:grade4

I need the avg field added after grade 4.

The calculation I used in the awk statement to print the extra field was:
($4*.5+$5*.2+$6*.1+$7*.2)

I can't get this into a file though. Any ideas would be greatly appreciated. Thanks
Code:
awk_command file >tmp
mv tmp file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to split a field into two fields?

Hi, I have a comma delimited text file where character fields (as opposed to numeric and date fields) are always enclosed with double quotes. Records are separated by the newline character. In a shell script I would like to split a particular field into two separate fields (enclosed with double... (4 Replies)
Discussion started by: vbrown
4 Replies

2. Shell Programming and Scripting

Adding new fields to an existing layout

Hi Everybody, I have an layout file like below f1 1 char 10, f2 11 char 2, f3 13 char 1, lineend 14 char 1 Their I need to add a new field which would be like f5 char 3, f6 char 2 The o/p should be f1 1 char 10, f2 11 char 2, f3 13 char 1, f5 14 char 3, f6 17 char 2 (3 Replies)
Discussion started by: mr_manii
3 Replies

3. Shell Programming and Scripting

Sorting on two fields time field and number field

Hi, I have a file that has data in it that says 00:01:48.233 1212 00:01:56.233 345 00:09:01.221 5678 00:12:23.321 93444 The file has more line than this but i just wanted to put in a snippet to ask how I would get the highest number with time stamp into another file. So from the above... (2 Replies)
Discussion started by: pat4519
2 Replies

4. Shell Programming and Scripting

Need help in writing a script to create a new text file with specific data from existing two files

Hi, I have two text files. Need to create a third text file extracting specific data from first two existing files.. Text File 1: Format contains: SQL*Loader: Release 10.2.0.1.0 - Production on Wed Aug 4 21:06:34 2010 some text ............so on...and somwhere text like: Record 1:... (1 Reply)
Discussion started by: shashi143ibm
1 Replies

5. Shell Programming and Scripting

compare two fields and get a third field

Hello, I'm trying to get a value based on a comparison of two fields, this is: file1 687.45 687.18 687.322 687.405 686.865 file 2 685 6.43 686 6.43 687 6.42 688 6.42 (3 Replies)
Discussion started by: Gery
3 Replies

6. HP-UX

Create a new user from using existing users profile

Hello, Just wanting to know if it is possible. Also I am new to command line. I am running 5.1b, if that matters. Thanks in advance (10 Replies)
Discussion started by: bcha
10 Replies

7. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Discussion started by: 100bees
6 Replies

8. Shell Programming and Scripting

Help in splitting Sub Fields and compare with other field

Hi All, We are trying to pull out data from below table, the table contains four fields and out of which last two fields are having sub-fields with delimiter $, we want to identify number "1" position in the 3rd field and from 4th field need to extract the information from the same position. ... (4 Replies)
Discussion started by: rramkrishnas
4 Replies

9. Shell Programming and Scripting

Inserting a field without disturbing field separator on other fields

Hi All, I have the input as below: cat input 032016002 2.891 97.109 16.605 27.172 24.017 32.207 0.233 0.021 39.810 0.077 0.026 19.644 13.882 0.131 11.646 0.102 11.449 76.265 23.735 16.991 83.009 8.840 91.160 0.020 99.980 52.102 47.898 44.004 55.996 39.963 18.625 0.121 1.126 40.189... (15 Replies)
Discussion started by: am24
15 Replies

10. What is on Your Mind?

New Buttons to Create New Discussions and Reply to Existing One

You may have noticed a lot of big blue buttons" on the site, replacing the Font Awesome icons for creating new discussions and replying to discussions. Here are the reasons for this change: A number of unix.com moderators, including Don Cragun and Ravinder Singh, have commented that new... (6 Replies)
Discussion started by: Neo
6 Replies
Biber::Entry::Name(3pm) 				User Contributed Perl Documentation				   Biber::Entry::Name(3pm)

NAME
Biber::Entry::Name - Biber::Entry::Name objects new Initialize a Biber::Entry::Name object, optionally with key=>value arguments. Ex: Biber::Entry::Name->new( lastname=>"Bolzmann", firstname=>"Anna Maria", prefix => "von" ) TO_JSON Serialiser for JSON::XS::encode notnull Test for an empty object was_stripped Return boolean to tell if the passed field had braces stripped from the original set_hash Set a hash for the name get_hash Get a hash for the name set_index Set a field telling what position in the name list the name is get_index Get the index of a Biber::Entry::Name object set_uniquename Set uniquename for a visible Biber::Entry::Name object Sets global flag to say that some uniquename value has changed set_uniquename_all Set uniquename for a Biber::Entry::Name object get_uniquename Get uniquename for a visible Biber::Entry::Name object get_uniquename_all Get uniquename for a Biber::Entry::Name object reset_uniquename Reset uniquename for a Biber::Entry::Name object set_minimal_info Set the string of lastnames and string of fullnames Used to track uniquename=5 or 6 get_minimal_info Get the name context used to track uniquename=5 or 6 get_namepart Get a namepart by passed name set_firstname Set firstname for a Biber::Entry::Name object get_firstname Get firstname for a Biber::Entry::Name object get_firstname_i Get firstname initials for a Biber::Entry::Name object set_middlename Set middlename for a Biber::Entry::Name object get_middlename Get middlename for a Biber::Entry::Name object get_middlename_i Get middlename initials for a Biber::Entry::Name object set_lastname Set lastname for a Biber::Entry::Name object get_lastname Get lastname for a Biber::Entry::Name object get_lastname_i Get lastname initials for a Biber::Entry::Name object set_suffix Set suffix for a Biber::Entry::Name object get_suffix Get suffix for a Biber::Entry::Name object get_suffix_i Get suffix initials for a Biber::Entry::Name object set_prefix Set prefix for a Biber::Entry::Name object get_prefix Get prefix for a Biber::Entry::Name object get_prefix_i Get prefix initials for a Biber::Entry::Name object set_gender Set gender for a Biber::Entry::Name object get_gender Get gender for a Biber::Entry::Name object set_namestring Set namestring for a Biber::Entry::Name object get_namestring Get namestring for a Biber::Entry::Name object set_nameinitstring Set nameinitstring for a Biber::Entry::Name object get_nameinitstring Get nameinitstring for a Biber::Entry::Name object name_to_bbl { Return bbl data for a name name_to_bltxml { Add BibLaTeXML for the name to an XML::Writer object dump Dump Biber::Entry::Name object AUTHORS
Francois Charette, "<firmicus at ankabut.net>" Philip Kime "<philip at kime.org.uk>" BUGS
Please report any bugs or feature requests on our sourceforge tracker at <https://sourceforge.net/tracker2/?func=browse&group_id=228270>. COPYRIGHT &; LICENSE Copyright 2009-2012 Francois Charette and Philip Kime, all rights reserved. This module is free software. You can redistribute it and/or modify it under the terms of the Artistic License 2.0. This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. perl v5.14.2 2012-06-17 Biber::Entry::Name(3pm)
All times are GMT -4. The time now is 06:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy