Sponsored Content
Top Forums UNIX for Beginners Questions & Answers UNIX script to compare 3rd column value with first column and display Post 303033442 by rbatte1 on Friday 5th of April 2019 10:16:24 AM
Old 04-05-2019
Hello sekhar.lsb,

I am confused. If you file is called INput, what is wrong with just sort INput ?

How is EPIC1 router EPIC2 Targetdefinition to match up?


Can you provide more data and show what we need to match and what to avoid please. I'd like to help, but the rules you want to follow are not clear.


Thanks, in advance,
Robin
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare files column to column based on keys

Here is my situation. I need to compare two tab separated files (diff is not useful since there could be known difference between files). I have found similar posts , but not fully matching.I was thinking of writing a shell script using cut and grep and while loop but after going thru posts it... (2 Replies)
Discussion started by: blackjack101
2 Replies

2. Shell Programming and Scripting

Compare Two Files(Column By Column) In Perl or shell

Hi, I am writing a comparator script, which comapre two txt files(column by column) below are the precondition of this comparator 1)columns of file are not seperated Ex. file1.txt 8888812341181892 1243548895685687 8945896789897789 1111111111111111 file2.txt 9578956789567897... (2 Replies)
Discussion started by: kumar96877
2 Replies

3. Shell Programming and Scripting

AWK script to create max value of 3rd column, grouping by first column

Hi, I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column. clientname,day-of-month,max-users ----------------------------------- client1,20120610,5 client2,20120610,2 client3,20120610,7... (3 Replies)
Discussion started by: ckmehta
3 Replies

4. UNIX for Dummies Questions & Answers

sort a unix file by 3rd column

Hi, Can anybody tell me how to sort a unix file by 3rd column and not by ltr? Please help Thanks in advance (2 Replies)
Discussion started by: vinnyvirk
2 Replies

5. UNIX for Dummies Questions & Answers

Search word in 3rd column and move it to next column (4th)

Hi, I have a file with +/- 13000 lines and 4 column. I need to search the 3rd column for a word that begins with "SAP-" and move/skip it to the next column (4th). Because the 3rd column need to stay empty. Thanks in advance.:) 89653 36891 OTR-60 SAP-2 89653 36892 OTR-10 SAP-2... (2 Replies)
Discussion started by: AK47
2 Replies

6. Shell Programming and Scripting

Help with compare two column and print out column with smallest number

Input file : 5 20 500 2 20 41 41 0 23 1 Desired output : 5 2 20 0 1 By comparing column 1 and 2 in each line, I hope can print out the column with smallest number. I did try the following code, but it don't look good :( (2 Replies)
Discussion started by: perl_beginner
2 Replies

7. Shell Programming and Scripting

Compare 3rd column in 2 files

I have the following 2 files. File 1 08FB,000192602673,10000000c9a6b240 0121,000192602673,20000025b550101f 0121,000192602673,20000025b550100f 08FA,000192602673,10000000c9a6b240 File 2 18F2,000195702363,10000000c9a6b240 18F3,000195702363,10000000c9a6b240... (2 Replies)
Discussion started by: kieranfoley
2 Replies

8. Shell Programming and Scripting

Changing values only in 3rd column and 4th column

#cat file testing test! nipw asdkjasjdk ok! what !ok host server1 check_ssh_disk!102.56.1.101!30!50!/ other host server 2 des check_ssh_disk!192.6.1.10!40!30!/ #grep check file| awk -F! '{print $3,$4}'|awk '{gsub($1,"",$1)}1' 50 30 # Output: (6 Replies)
Discussion started by: kenshinhimura
6 Replies

9. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

10. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies
SQL::Eval(3)						User Contributed Perl Documentation					      SQL::Eval(3)

NAME
SQL::Eval - Base for deriving evalution objects for SQL::Statement SYNOPSIS
require SQL::Statement; require SQL::Eval; # Create an SQL statement; use a concrete subclass of # SQL::Statement my $stmt = MyStatement->new("SELECT * FROM foo, bar", SQL::Parser->new('Ansi')); # Get an eval object by calling open_tables; this # will call MyStatement::open_table my $eval = $stmt->open_tables($data); # Set parameter 0 to 'Van Gogh' $eval->param(0, 'Van Gogh'); # Get parameter 2 my $param = $eval->param(2); # Get the SQL::Eval::Table object referring the 'foo' table my $fooTable = $eval->table('foo'); DESCRIPTION
This module implements two classes that can be used for deriving concrete subclasses to evaluate SQL::Statement objects. The SQL::Eval object can be thought as an abstract state engine for executing SQL queries, the SQL::Eval::Table object can be considered a *very* table abstraction. It implements method for fetching or storing rows, retrieving column names and numbers and so on. See the "test.pl" script as an example for implementing a concrete subclass. While reading on, keep in mind that these are abstract classes, you *must* implement at least some of the methods describe below. Even more, you need not derive from SQL::Eval or SQL::Eval::Table, you just need to implement the method interface. All methods just throw a Perl exception in case of errors. Method interface of SQL::Eval new Constructor; use it like this: $eval = SQL::Eval->new(\%attr); Blesses the hash ref \%attr into the SQL::Eval class (or a subclass). param Used for getting or setting input parameters, as in the SQL query INSERT INTO foo VALUES (?, ?); Example: $eval->param(0, $val); # Set parameter 0 $eval->param(0); # Get parameter 0 params Likewise used for getting or setting the complete array of input parameters. Example: $eval->params($params); # Set the array $eval->params(); # Get the array table Returns or sets a table object. Example: $eval->table('foo', $fooTable); # Set the 'foo' table object $eval->table('foo'); # Return the 'foo' table object column Return the value of a column with a given name; example: $col = $eval->column('foo', 'id'); # Return the 'id' column of # the current row in the # 'foo' table This is equivalent and just a shorthand for $col = $eval->table('foo')->column('id'); Method interface of SQL::Eval::Table new Constructor; use it like this: $eval = SQL::Eval::Table->new(\%attr); Blesses the hash ref \%attr into the SQL::Eval::Table class (or a subclass). row Used to get the current row as an array ref. Do not mismatch getting the current row with the fetch_row method! In fact this method is valid only after a successfull "$table->fetchrow()". Example: $row = $table->row(); column Get the column with a given name in the current row. Valid only after a successfull "$table->fetchrow()". Example: $col = $table->column($colName); column_num Return the number of the given column name. Column numbers start with 0. Returns undef, if a column name is not defined, so that you can well use this for verifying valid column names. Example: $colNum = $table->column_num($colNum); column_names Returns an array ref of column names. The above methods are implemented by SQL::Eval::Table. The following methods aren't, so that they *must* be implemented by concrete subclassed. See the "test.pl" script for example. fetch_row Fetches the next row from the table. Returns "undef", if the last row was already fetched. The argument $data is for private use of the concrete subclass. Example: $row = $table->fetch_row($data); Note, that you may use $row = $table->row(); for retrieving the same row again, until the next call of "fetch_row". push_row Likewise for storing rows. Example: $table->push_row($data, $row); push_names Used by the CREATE TABLE statement to set the column names of the new table. Receives an array ref of names. Example: $table->push_names($data, $names); seek Similar to the seek method of a filehandle; used for setting the number of the next row being written. Example: $table->seek($data, $whence, $rowNum); Actually the current implementation is using only "seek($data, 0,0)" (first row) and "seek($data, 2,0)" (last row, end of file). truncate Truncates a table after the current row. Example: $table->truncate($data); INTERNALS
The current implementation is quite simple: An SQL::Eval object is an hash ref with only two attributes. The "params" attribute is an array ref of parameters. The "tables" attribute is an hash ref of table names (keys) and table objects (values). SQL::Eval::Table instances are implemented as hash refs. Used attributes are "row" (the array ref of the current row), "col_nums" (an hash ref of column names as keys and column numbers as values) and "col_names", an array ref of column names with the column numbers as indexes. MULTITHREADING
All methods are working with instance-local data only, thus the module is reentrant and thread safe, if you either don't share handles between threads or grant serialized use. AUTHOR AND COPYRIGHT
This module is Copyright (C) 1998 by Jochen Wiedmann Am Eisteich 9 72555 Metzingen Germany Email: joe@ispsoft.de Phone: +49 7123 14887 All rights reserved. You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file. SEE ALSO
SQL::Statement(3) perl v5.12.1 2010-05-06 SQL::Eval(3)
All times are GMT -4. The time now is 05:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy