awk script to perform an action similar to vlookup between two csv files in UNIX Post: 302915510

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perform action file name written to the pipe

Hello, I have a script that monitors files uploaded via ftp. After a successful upload, the file name is written to the pipe. There is another program that reads this pipe and allows automatically run any program or script ( say test.sh ) to process the newly uploaded file. cat test.sh...

2. Shell Programming and Scripting

Sed or awk script to remove text / or perform calculations from large CSV files

I have a large CSV files (e.g. 2 million records) and am hoping to do one of two things. I have been trying to use awk and sed but am a newbie and can't figure out how to get it to work. Any help you could offer would be greatly appreciated - I'm stuck trying to remove the colon and wildcards in...

3. Shell Programming and Scripting

Need help in searching 2 files for strings then perform an action

I have 2 files. I basically want to search both of them to see if the 1st column ($1) matches and if it matches then check to see if the 2nd column ($2) matches, then execute some code showing the results of the matches. File 1: AAA 123 misc blah BBB 456 CCC 789 File 2: ...

4. Shell Programming and Scripting

shell script - search a file and perform some action

hi, i have a service on unix platform, it will generate traces in a particular folder i want to check using shell script if traces exist, then perform some action else continue to be in loop. filename is service.tra can you please help? thanks

5. Shell Programming and Scripting

How to access files from different directories and to perform search action in those files?

Hi, I want to access files from different directories (for example: /home/dir1/file1 , /home/dir2/file2 ...) Like this i have to access these files(file1, file2...).

6. Shell Programming and Scripting

Computing the ratio of similar columns in the two files using awk script

Thanks Bartus11 for your help in the following code to compare the two files "t1" and "t2". awk 'NR==FNR{a=1;next}$2 in a{print $2}' t1 t2 First can anyone explain that what is the purpose of assigning a =1? Second, the current script is printing out the matched columns between the...

7. Shell Programming and Scripting

Script to monitor for new file with ext .err and size > 0 bytes and perform a action or command

Hi All, I need to create a script to monitor a dir for new files with ext .err and also it should b a non empty files. and perform a action or command . We have a new ETL application that runs on a linux server, every times a etl fails it creates a .err file or updates the existing .err...

8. Shell Programming and Scripting

Vlookup using awk non similar files

I need to vlookup and check the server not found. Source file 1 server1 server2 server3 server4 server5_root server6_silver server7 server7-test server7-temp Source file 2 server1_bronze

9. UNIX for Beginners Questions & Answers

How to compare two files in UNIX using similar to vlookup?

Hi, I want to compare same column in two files, if values match then display the column or display "NA". Ex : File 1 : 123 abc xyz pqr File 2: 122 aab fdf pqr fff qqq rrr

LEARN ABOUT DEBIAN

net::proxy::connector::dual

Net::Proxy::Connector::dual(3pm)			User Contributed Perl Documentation			  Net::Proxy::Connector::dual(3pm)

NAME

       Net::Proxy::Connector::dual - Y-shaped Net::Proxy connector

DESCRIPTION

       "Net::Proxy::Connecter::dual" is a "Net::Proxy::Connector" that can forward the connection to two distinct services, based on the client
       connection, before any data is exchanged.

CONNECTOR OPTIONS

       This connector can only work as an "in" connector.

       The "server_first" and "client_first" options are required: they are hashrefs containing the options necessary to create two "out"
       "Net::Proxy::Connector" objects that will be used to connect to the requested service.

       The "Net::Proxy::Connector::dual" object decides between the two services by waiting during a short timeout. If the client sends some data
       directly, then it is connected via the "client_first" connector. Otherwise, at the end of the timeout, it is connected via the
       "server_first" connector.

       o   host

	   The hostname on which the connector will listen for client connections.  Default is "localhost".

       o   port

	   The port on which the connector will listen for client connections.

       o   server_first

	   Typically an "out" connector to a SSH server or any service that sends a banner line.

       o   client_first

	   Typically an "out" connectrot to a web server or SSL server.

       o   timeout

	   The timeout in seconds (can be decimal) to make a decision.	Default is 1 second.

AUTHOR

       Philippe 'BooK' Bruhat, "<book@cpan.org>".

ACKNOWLEDGMENTS

       This module is based on a script named sslh, which I wrote with Frederic Ple "<sslh@wattoo.org>" (who had the original insight about the
       fact that not all servers speak first on the wire).

       Frederic wrote a C program, while I wrote a Perl script (based on my experience with connect-tunnel).

       Now that "Net::Proxy" is available, I've ported the Perl script to use it.

COPYRIGHT

       Copyright 2006 Philippe 'BooK' Bruhat, All Rights Reserved.

LICENSE

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.10.1							    2009-10-18					  Net::Proxy::Connector::dual(3pm)