Sponsored Content
Full Discussion: Column update
Top Forums Shell Programming and Scripting Column update Post 302306441 by giannicello on Sunday 12th of April 2009 08:41:08 PM
Old 04-12-2009
Column update

I have two files:

fileA
a,b,c,10,apple
a,b,c,20,orange
a,b,c,10,grape
d,e,f,5,pear
d,e,f,100,pear
x,y,z,15,lemon
x,y,z,20,apple
x,y,z,30,grape

fileB
a,b,c,20
d,e,f,100
x,y,z,30

If col1=col1,col2=col2 and col3=3 of fileA to fileB, then take value in 4th col of fileB and replace it in fileA...so I get this:

desired output:
a,b,c,20,apple
a,b,c,20,orange
a,b,c,20,grape
d,e,f,100,pear
x,y,z,30,lemon
x,y,z,30,apple
x,y,z,30,grape

is while within while my only option or does someone know an awk solution that can do this faster, especially if the files will be very large?

Thanks.
G
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To update a column in a table through shell script

Hi All, I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking. Something like this, through... (3 Replies)
Discussion started by: shilpa_acc
3 Replies

2. Shell Programming and Scripting

Update a column value in csv files

Hi all I am new to scripting and i have an application from which i will export into a csv file as follows Column1, Column2, Column3 Sno1, Folder\Test.txt, Fail Sno2, Folder\Test1.txt, Pass Sno3, Folder\Test2.txt, Fail Now i need to change the column2 in all the rows from "Folder\" ... (1 Reply)
Discussion started by: rajeshrp
1 Replies

3. Web Development

Mysql question: Best way to update a column containing 8 million rows

Hi all, I was wondering if anyone knew a good/safe way to update a single column in a table that could contain upto 8 million rows... simple command like: UPDATE set blah=foo where bar=XXX; I will be running this on tables being written to and tables that have already been created. ... (3 Replies)
Discussion started by: muay_tb
3 Replies

4. Shell Programming and Scripting

Update file to add as last column

I need to update a text file within a loop so that the value is added creating a new column at the end. I cannot use paste because I dont know the number of files. If I use >> the value is added after the last row. Please help. For example: Input file: Column 1 Column2 - ... (2 Replies)
Discussion started by: Surabhi_so_mh
2 Replies

5. Shell Programming and Scripting

Add column and update file

I have to update my file from server file. Server file A on location serverfile="/orf/ddl/plokall/fileA" myfile=""/orf/ddl/plokall/myupdatedfile" fileA: KALKIKLOKPO001 10.1 HFJFKSLOKPO002 11.4 POLKAK5143 184.3 POLKJI5144 107.5 OKILDL5145 107.10 CVT0909 10.11 KJL0405... (3 Replies)
Discussion started by: asavaliya
3 Replies

6. Shell Programming and Scripting

Update column in File

I Have a file a.txt in the below format 1 23 50 1 25 6666666666666 1 23 34 If the third column value is greater than two digit then make it 0 New Data File --------------- a.txt 1 23 50 1 25 0 1 23 34 Need your help regarding this (5 Replies)
Discussion started by: deep_kol
5 Replies

7. Programming

Column update using Informix

Hi, I am using INFORMIX 8 and trying to update column value by apending '09' to existing record . update sample_data_table set Name = Name||22 where id = 90 and state = NY This worked fine in oracle Database,But throwing error in informix . I need output as Ravi22 for Ravi record in... (0 Replies)
Discussion started by: Perlbaby
0 Replies

8. Shell Programming and Scripting

Update a mysql column via bash script

Hello, I want to check the value of all MySQL columns.(column name is "status") via bash script. If value is "0" at I want to make only single column value to "1" I have many "0" values on mysql database(on "status" column) "0" means it is a draft post. I want to publish a post. I... (2 Replies)
Discussion started by: tara123
2 Replies

9. Shell Programming and Scripting

Update All Column Value by 1 if exist

Guys, Running on Linux Ubuntu. I need to find a method to automatically update all the rows for 2 columns and only if the rows not null. e.g : based on the example data below, I want to update all rows under column 2 and 3 (COL2, COL3) with an increment of 1 and only if the value is not... (7 Replies)
Discussion started by: faizalms
7 Replies

10. Programming

Update a column from a Join

Here is my select that I have to identify the child records that are Open (e.c7 < 6000) when the parent (t2068) c.c7 > 3 SELECT c.c1000000161, c.c7, c.c1000000019, e.c1000000829 FROM t2068 c INNER JOIN t1533 e ON e.c1000000829 = c.c301572100 where c.c7 > 3... (2 Replies)
Discussion started by: newborndba
2 Replies
YAML::Node(3pm) 					User Contributed Perl Documentation					   YAML::Node(3pm)

NAME
YAML::Node - A generic data node that encapsulates YAML information SYNOPSIS
use YAML; use YAML::Node; my $ynode = YAML::Node->new({}, 'ingerson.com/fruit'); %$ynode = qw(orange orange apple red grape green); print Dump $ynode; yields: --- !ingerson.com/fruit orange: orange apple: red grape: green DESCRIPTION
A generic node in YAML is similar to a plain hash, array, or scalar node in Perl except that it must also keep track of its type. The type is a URI called the YAML type tag. YAML::Node is a class for generating and manipulating these containers. A YAML node (or ynode) is a tied hash, array or scalar. In most ways it behaves just like the plain thing. But you can assign and retrieve and YAML type tag URI to it. For the hash flavor, you can also assign the order that the keys will be retrieved in. By default a ynode will offer its keys in the same order that they were assigned. YAML::Node has a class method call new() that will return a ynode. You pass it a regular node and an optional type tag. After that you can use it like a normal Perl node, but when you YAML::Dump it, the magical properties will be honored. This is how you can control the sort order of hash keys during a YAML serialization. By default, YAML sorts keys alphabetically. But notice in the above example that the keys were Dumped in the same order they were assigned. YAML::Node exports a function called ynode(). This function returns the tied object so that you can call special methods on it like ->keys(). keys() works like this: use YAML; use YAML::Node; %$node = qw(orange orange apple red grape green); $ynode = YAML::Node->new($node); ynode($ynode)->keys(['grape', 'apple']); print Dump $ynode; produces: --- grape: green apple: red It tells the ynode which keys and what order to use. ynodes will play a very important role in how programs use YAML. They are the foundation of how a Perl class can marshall the Loading and Dumping of its objects. The upcoming versions of YAML.pm will have much more information on this. AUTHOR
Ingy dA~Xt Net <ingy@cpan.org> COPYRIGHT
Copyright (c) 2006, 2011-2012. Ingy dA~Xt Net. All rights reserved. Copyright (c) 2002. Brian Ingerson. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See <http://www.perl.com/perl/misc/Artistic.html> perl v5.14.2 2012-04-18 YAML::Node(3pm)
All times are GMT -4. The time now is 03:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy