Global update on a file based on a table

Homework and Emergencies Emergency UNIX and Linux Support Global update on a file based on a table

01-20-2010

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

Code:

awk 'NR==FNR{T[-$1]=$2;next}$43=T[$43]' table FS="" OFS="" sample

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

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

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

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

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

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

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

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

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

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

LEARN ABOUT REDHAT

delete

DELETE(7)							   SQL Commands 							 DELETE(7)

NAME

       DELETE - delete rows of a table

SYNOPSIS

       DELETE FROM [ ONLY ] table [ WHERE condition ]

   INPUTS
       table  The name (optionally schema-qualified) of an existing table.

       condition
	      This is an SQL selection query which returns the rows which are to be deleted.

	      Refer to the SELECT statement for further description of the WHERE clause.

   OUTPUTS
       DELETE count
	      Message returned if items are successfully deleted. The count is the number of rows deleted.

	      If count is 0, no rows were deleted.

DESCRIPTION

       DELETE removes rows which satisfy the WHERE clause from the specified table.

       If the condition (WHERE clause) is absent, the effect is to delete all rows in the table.  The result is a valid, but empty table.

	      Tip: TRUNCATE [truncate(7)] is a PostgreSQL extension which provides a faster mechanism to remove all rows from a table.

       By  default  DELETE  will  delete  tuples in the table specified and all its sub-tables. If you wish to only update the specific table men-
       tioned, you should use the ONLY clause.

       You must have write access to the table in order to modify it, as well as read access to any table whose values are read in the condition.

USAGE

       Remove all films but musicals:

       DELETE FROM films WHERE kind <> 'Musical';
       SELECT * FROM films;

	code  | 	  title 	  | did | date_prod  |	kind   | len
       -------+---------------------------+-----+------------+---------+-------
	UA501 | West Side Story 	  | 105 | 1961-01-03 | Musical | 02:32
	TC901 | The King and I		  | 109 | 1956-08-11 | Musical | 02:13
	WD101 | Bed Knobs and Broomsticks | 111 |	     | Musical | 01:57
       (3 rows)

       Clear the table films:

       DELETE FROM films;
       SELECT * FROM films;

	code | title | did | date_prod | kind | len
       ------+-------+-----+-----------+------+-----
       (0 rows)

COMPATIBILITY

   SQL92
       SQL92 allows a positioned DELETE statement:

       DELETE FROM table WHERE
	   CURRENT OF cursor

       where cursor identifies an open cursor.	Interactive cursors in PostgreSQL are read-only.

SQL - Language Statements					    2002-11-22								 DELETE(7)

Emergency UNIX and Linux Support