Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Please correct my Script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Please correct my Script
# 8  
Old 04-04-2009
Quote:
Originally Posted by nuthalapati
Sorry siquadri,

prints nothing.

Code:
Did you change your input file names to file1 and file2

# 9  
Old 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$
# 10  
Old 04-04-2009
Quote:
Originally Posted by nuthalapati
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$
This is what i am getting

$ awk -F"," 'FILENAME="file1.txt" {array[$1]=$1} FILENAME="file2.txt" { if (array[$4]) {print $0}}' file1.txt file2.txt
1,2,ua,xyz.com
1,2,ua,eg.com
$
# 11  
Old 04-04-2009
What could have gone wrong ? this is strange

I use

Linux 2.6.9-22.ELsmp #1 SMP Sat Oct 8 19:11:43 CDT 2005 i686 i686 i386 GNU/Linux
# 12  
Old 04-05-2009
Siquadri, any idea why it could have failed at my end ?
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can some one correct this script

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

2. Shell Programming and Scripting

Need output of script on screen and file with correct return status of the called script.

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

3. Shell Programming and Scripting

Please Correct My script

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

4. Shell Programming and Scripting

Can anyone correct the error in this script

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

5. Shell Programming and Scripting

Please correct the error in the following script

#!/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. Emergency UNIX and Linux Support

Please correct my script

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

7. Shell Programming and Scripting

something is not write in the script. Can some one please correct this.

Wrong post (2 Replies)
Discussion started by: tuffEnuff
2 Replies

8. Shell Programming and Scripting

Is the script correct ???

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

9. Shell Programming and Scripting

Please Correct this Array Script

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
Login or Register to Ask a Question