Global update on a file based on a table

 
Thread Tools Search this Thread
Homework and Emergencies Emergency UNIX and Linux Support Global update on a file based on a table
# 8  
Old 01-20-2010
Code:
awk 'NR==FNR{T[-$1]=$2;next}$43=T[$43]' table FS="" OFS="" sample

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to update value based on pattern match in another file

In the awk, thanks you @RavinderSingh13, for the help in below, hopefully it is close as I am trying to update the value in $12 of the tab-delimeted file2 with the matching value in $1 of the space delimeted file1. I have added comments for each line as well. Thank you :). awk awk '$12 ==... (10 Replies)
Discussion started by: cmccabe
10 Replies

2. 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

3. Shell Programming and Scripting

awk to update file based on 5 conditions

I am trying to use awk to update the below tab-delimited file based on 5 different rules/conditions. The final output is also tab-delimited and each line in the file will meet one of the conditions. My attemp is below as well though I am not very confident in it. Thank you :). Condition 1: The... (10 Replies)
Discussion started by: cmccabe
10 Replies

4. UNIX for Dummies Questions & Answers

Select last update data based on file name

Hi All, I need to remove all files except the most update data based on date on filename Input data_AIDS_20150312.txt data_AIDS_20150311.txt data_AIDS_20150411.txt data_AIDS_20140312.txt the most updated data is data_AIDS_20150411.txt, so I'll remove other files. My expected output... (3 Replies)
Discussion started by: radius
3 Replies

5. Shell Programming and Scripting

Update the table using values from a csv file

i want to run update query for oracle which is in up.sql taking values from a.csv. I have implemented shell script to do it. extn="perl" ls -1 | while read file do echo "$file,$extn" > a.csv done up.sql contains update file_list set filename=$1 where extn=$2; The code to update is... (2 Replies)
Discussion started by: millan
2 Replies

6. UNIX for Dummies Questions & Answers

How to Update DB table from txt file using CRONJOB in Unix Shell Script

Hi Experts, can guide how we can Update a Database Table using a txt file source Using Unix Shell Scripts. What are the Cron Jobs codes can written to Update DB table. txt file contains record like data. US 09/03/2012 User DocType DocID. these above feilds in txt files need to be updated in... (4 Replies)
Discussion started by: mahesh.sap
4 Replies

7. Shell Programming and Scripting

clean passwd file based on db table (master)

The purpose of this script is to scan the /etc/passwd file one line at a time comparing the usernames to the usernames found in a database table. I will later locked every account which is not in the database table. I have export the userlist from the database in a file (/tmp/userlist). It... (1 Reply)
Discussion started by: Banks187
1 Replies

8. Shell Programming and Scripting

Update a field in a file based on condition

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

9. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
Login or Register to Ask a Question
Font::TTF::Table(3pm)					User Contributed Perl Documentation				     Font::TTF::Table(3pm)

NAME
Font::TTF::Table - Superclass for tables and used for tables we don't have a class for DESCRIPTION
Looks after the purely table aspects of a TTF table, such as whether the table has been read before, locating the file pointer, etc. Also copies tables from input to output. INSTANCE VARIABLES
Instance variables start with a space read Flag which indicates that the table has already been read from file. dat Allows the creation of unspecific tables. Data is simply output to any font file being created. INFILE The read file handle OFFSET Location of the file in the input file LENGTH Length in the input directory CSUM Checksum read from the input file's directory PARENT The Font::TTF::Font that table is part of METHODS
Font::TTF::Table->new(%parms) Creates a new table or subclass. Table instance variables are passed in at this point as an associative array. $t->read Reads the table from the input file. Acts as a superclass to all true tables. This method marks the table as read and then just sets the input file pointer but does not read any data. If the table has already been read, then returns "undef" else returns $self $t->read_dat Reads the table into the "dat" instance variable for those tables which don't know any better $t->out($fh) Writes out the table to the font file. If there is anything in the "data" instance variable then this is output, otherwise the data is copied from the input file to the output $t->out_xml($context) Outputs this table in XML format. The table is first read (if not already read) and then if there is no subclass, then the data is dumped as hex data $t->XML_element Output a particular element based on its contents. $t->XML_end($context, $tag, %attrs) Handles the default type of <data> for those tables which aren't subclassed $t->dirty($val) This sets the dirty flag to the given value or 1 if no given value. It returns the value of the flag $t->update Each table knows how to update itself. This consists of doing whatever work is required to ensure that the memory version of the table is consistent and that other parameters in other tables have been updated accordingly. I.e. by the end of sending "update" to all the tables, the memory version of the font should be entirely consistent. Some tables which do no work indicate to themselves the need to update themselves by setting isDirty above 1. This method resets that accordingly. $t->empty Clears a table of all data to the level of not having been read $t->release Releases ALL of the memory used by this table, and all of its component/child objects. This method is called automatically by 'Font::TTF::Font->release' (so you don't have to call it yourself). NOTE, that it is important that this method get called at some point prior to the actual destruction of the object. Internally, we track things in a structure that can result in circular references, and without calling '"release()"' these will not properly get cleaned up by Perl. Once this method has been called, though, don't expect to be able to do anything with the "Font::TTF::Table" object; it'll have no internal state whatsoever. Developer note: As part of the brute-force cleanup done here, this method will throw a warning message whenever unexpected key values are found within the "Font::TTF::Table" object. This is done to help ensure that any unexpected and unfreed values are brought to your attention so that you can bug us to keep the module updated properly; otherwise the potential for memory leaks due to dangling circular references will exist. BUGS
No known bugs AUTHOR
Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing. perl v5.10.1 2009-01-21 Font::TTF::Table(3pm)