04-04-2009
Here is what i did
-bash-2.05b$ cat file1.txt
laeg.com,2/2/23,a,b,ga
aeg.com,2/2/23,a,b,ga
xyz.com,2/2/12,a,b,c
eg.com,2/2/23,a,b,ga
-bash-2.05b$ cat file2.txt
1,2,ua,xyz.com
1,2,ua,abc.com
1,2,ua,eg.com
1,2,ua,easg.com
1,2,ua,zth.com
-bash-2.05b$
-bash-2.05b$ awk -F"," 'FILENAME="file1.txt" {array[$1]=$1} FILENAME="file2.txt" { if (array[$4]) {print $0}}' file1.txt file2.txt
-bash-2.05b$ awk -F"," 'FILENAME="file1.txt" {array[$1]=$1} FILENAME="file2.txt" { if (array[$4]) {print $0}}' file1.txt file2.txt > file3.txt
-bash-2.05b$ cat file3.txt
-bash-2.05b$
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Here is the script. I am not able to increment and Print echo "2=" ${arr}
(Bold line)
Can someone please help me correct it? I am thinking there is some escape sequence error. Just started learning scripts ...
Thanks
#!/bin/ksh
set -A arr a1 a2 a3 a4
# START
Server1=gmi
... (6 Replies)
Discussion started by: psreddy1234
6 Replies
2. Shell Programming and Scripting
Dear Collegues is the below given is correct ?
#!/usr/bin/perl
$a = @ARGV;
while ($a = @ARGV) {
exec "./jagan ../dat/ml_in @ARGV";
}
Jagan (0 Replies)
Discussion started by: jaganadh
0 Replies
3. Shell Programming and Scripting
Wrong post (2 Replies)
Discussion started by: tuffEnuff
2 Replies
4. Emergency UNIX and Linux Support
Please correct my script if it any exceptional, since im calling other external script with in my script.
#!/bin/bash
FE1=TMM
DT1=/home/myHome/dated_1
REPORT=/home/otherHome/Report.sh
## Run the report for FE1 & DT1
cd /home/myHome
SERV_LST=/home/myHome/srvc-lst
echo "Welcome to... (5 Replies)
Discussion started by: raghunsi
5 Replies
5. Shell Programming and Scripting
#!/bin/ksh
db_user=$DB_USER_NAME
db_pwd=$DB_PASSWORD
db_sid=$TWO_TASK
if ; then
echo "\tUsage: MoveUsageProcessing <BC Log file Name>"
exit 1
else
BCLogFileName=$1
fi
grep -i 'MoveUsage daemon needs to run on this account before it can be billed' $1 |awk -F\| '{for(i=0;++i<=NF;) if($i ~... (1 Reply)
Discussion started by: Rajesh Putnala
1 Replies
6. Shell Programming and Scripting
ret=`sqlplus -s /nolog << EOF
connect $db_user/$db_pwd@$db_sid;
SPOOL ./$DirectoryName/TableData.txt;
set pagesize 0 feedback off verify off heading off echo off linesize 150
while read var_ack_party_name
do
select * from bus_event where ack_party_name like... (13 Replies)
Discussion started by: rkrish
13 Replies
7. Shell Programming and Scripting
###############
#filename.sh
###############
CUREENT_DATE=02
log_file_path="$CUREENT_DATE"-"${0##%*/}`|cut -d "." -f1|awk -F "/" '{print $NF}'`"".log"
echo $log_file_path
################
#output required
02-filename.log (6 Replies)
Discussion started by: mohitmehral
6 Replies
8. Shell Programming and Scripting
Hi,
I am trying to capture logs of the script in the file as well as on the screen. I have used exec and tee command for this. While using exec command I am getting the correct output in the file but, script output is not getting displayed on the screen as it get executed.
Below is my sample... (14 Replies)
Discussion started by: Prathmesh
14 Replies
9. Shell Programming and Scripting
Hi,
I tried writing a script and there was a problem with SFTP part
can some one correct where is is the mistake
Enveronment file
#!/bin/bash
export HOST_NAME=<>
export USER_NAME=<>
export PASSWORD=<>
export SOURCE_PATH=/u03/informatica/current/server/infa_shared/TgtFiles/mfg
export... (4 Replies)
Discussion started by: spradeep86
4 Replies
LEARN ABOUT DEBIAN
sc_warts2text
SC_WARTS2TEXT(1) BSD General Commands Manual SC_WARTS2TEXT(1)
NAME
sc_warts2text -- simple dump of information contained in a warts file.
SYNOPSIS
sc_warts2text [-d ip2descr-file] [file ...]
DESCRIPTION
The sc_warts2text utility provides a simple dump of information contained in a sequence of warts files. The output is the same as that which
would have been provided by scamper if the text output option had been chosen instead of the warts output option when the data was collected.
The options are as follows:
-d ip2descr-file
specifies the name of a file with IP-address, description mappings, one mapping per line. See the examples section for further
information.
While the output of sc_warts2text is structured and suitable for initial analyses of results, the format of the output is not suitable for
automated parsing and analysis as the output of sc_warts2text will change overtime with no regard to backwards compatibility. Analyses of
the contents of a warts file should be made using specialised programs which link against the scamper file API.
EXAMPLES
The command:
sc_warts2text file1.warts file2.warts
will decode and print the contents of file1.warts, followed by the contents of file2.warts.
The command:
gzcat file1.warts.gz | sc_warts2text
will print the contents of the uncompressed file supplied on stdin.
Given a set of IP-address, description pairs in a file name mappings.txt:
192.0.2.1 "foo"
192.0.2.2 "bar"
then the command gzcat file1.warts.gz | sc_warts2text -d mappings.txt will print the description associated with a given destination address
before each result is presented.
SEE ALSO
scamper(1), sc_wartsdump(1)
AUTHORS
sc_warts2text is written by Matthew Luckie <mjl@luckie.org.nz>.
BSD
October 15, 2010 BSD