UNIX script to compare 3rd column value with first column and display

10 More Discussions You Might Find Interesting

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

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

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

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

5. 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 :(

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

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

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

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

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

LEARN ABOUT SUSE

alter_view

ALTER 
VIEW(7)							   SQL Commands 						     ALTER VIEW(7)

NAME

       ALTER VIEW - change the definition of a view

SYNOPSIS

       ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression
       ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT
       ALTER VIEW name OWNER TO new_owner
       ALTER VIEW name RENAME TO new_name
       ALTER VIEW name SET SCHEMA new_schema

DESCRIPTION

       ALTER VIEW changes various auxiliary properties of a view. (If you want to modify the view's defining query, use CREATE OR REPLACE VIEW.)

       You  must  own the view to use ALTER VIEW.  To change a view's schema, you must also have CREATE privilege on the new schema.  To alter the
       owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the view's  schema.
       (These  restrictions  enforce  that altering the owner doesn't do anything you couldn't do by dropping and recreating the view.	However, a
       superuser can alter ownership of any view anyway.)

PARAMETERS

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

       SET/DROP DEFAULT
	      These forms set or remove the default value for a column.  A default value associated with a view column	is  inserted  into  INSERT
	      statements on the view before the view's ON INSERT rule is applied, if the INSERT does not specify a value for the column.

       new_owner
	      The user name of the new owner of the view.

       new_name
	      The new name for the view.

       new_schema
	      The new schema for the view.

NOTES

       For historical reasons, ALTER TABLE can be used with views too; but the only variants of ALTER TABLE that are allowed with views are equiv-
       alent to the ones shown above.

EXAMPLES

       To rename the view foo to bar:

       ALTER VIEW foo RENAME TO bar;

COMPATIBILITY

       ALTER VIEW is a PostgreSQL extension of the SQL standard.

SEE ALSO

       CREATE VIEW [create_view(7)], DROP VIEW [drop_view(7)]

SQL - Language Statements					    2010-05-14							     ALTER VIEW(7)

UNIX for Beginners Questions & Answers