Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Challenging Compare and validate question -- plus speed.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Challenging Compare and validate question -- plus speed.
# 22  
Old 05-25-2006
Thank You again Vgersh99....

These are the sample files that I created..

Metadata File
PHP Code:
M       ORBITZ     
M       AIRTRAN
M       FRONTIER
M       CAESAR
M       BESTWESTERN 
Detail File
PHP Code:
D       ORBITZ     
D       AIRTRAN
D       FRONTIER
D       MIDWEST
D       MIDWEST
D       MIDWEST
D       MIDWEST
D       BESTWESTERN 
I am getting the output as

Code:
Detail partner name [ORBITZ] found in Metadata-- Successful
Detail partner name [AIRTRAN] found in Metadata-- Successful
Detail partner name [FRONTIER] found in Metadata-- Successful
Detail partner name [MIDWEST] NOT found in Metadata-- Failed
Detail partner name [MIDWEST] NOT found in Metadata-- Failed
Detail partner name [MIDWEST] NOT found in Metadata-- Failed
Detail partner name [MIDWEST] NOT found in Metadata-- Failed
Detail partner name [BESTWESTERN] found in Metadata-- Successful

If I have 5 million records for MIDWEST in the actual production file, the printf statement output will be huge.

I need the output printed out...But Is there any way that I could suppress the huge output and keep it to just one line like...Something like this

Code:
Detail partner name [ORBITZ] found in Metadata-- Successful
Detail partner name [AIRTRAN] found in Metadata-- Successful
Detail partner name [FRONTIER] found in Metadata-- Successful
Detail partner name [MIDWEST] NOT found in Metadata-- Failed
Detail partner name [BESTWESTERN] found in Metadata-- Successful

Please advice..

Thank You,
Madhu
# 23  
Old 05-25-2006
look into 'man sort'
# 24  
Old 05-25-2006
I did vgersh99...

I understand we can use
Code:
sort -u

to output only unique values...But not sure how I can use in the current code to suppress the output to only one row..
# 25  
Old 05-25-2006
You should really start experimenting yourself and stop relying on the complete solutions on these forums.

nawk '.....' File1 File2 | sort -u
Last edited by vgersh99; 05-25-2006 at 08:01 PM..
# 26  
Old 05-26-2006
I apologize vgersh99...I was trying my best and I am new to this whole scripting world....

Thank you and will experiment a little more before I ask the forum..

Have a nice day!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to compare files and validate order of headers

The below awk verifies the count and order of each text file in the directory. The script does execute and produce output, however the order of the headers are not compared to key. The portion in bold is supposed to do that. If the order of the headers in each text file is the same as key, then... (0 Replies)
Discussion started by: cmccabe
0 Replies

2. Programming

Generic speed question (PHP vs.)

Hi, On a hosted linux environment which I have very little control over, I have a PHP script that takes in X number of floats, performs Y number of simple recursive arithmetic calculations, and produces some output for display to the user. When I first created the script, 'X' and 'Y' were... (4 Replies)
Discussion started by: MoreCowbell
4 Replies

3. Shell Programming and Scripting

Challenging scenario

Hi, My input file contains 1,2 2,4 3,6 4,9 9,10 My expected output is 1,10 2,10 3,6 4,1 9,10 (6 Replies)
Discussion started by: pandeesh
6 Replies

4. Shell Programming and Scripting

Another validate input Question.

I'm writing a bash shell script to 'help' me post to susepaste (I can NEVER remember the time options). Here's the code: #!/bin/bash ########## # # Project : personal script. # Started : Wed Aug 03, 2011 # Author : Habitual # Description : susepaste c-li script with user... (5 Replies)
Discussion started by: Habitual
5 Replies

5. Filesystems, Disks and Memory

data from blktrace: read speed V.S. write speed

I analysed disk performance with blktrace and get some data: read: 8,3 4 2141 2.882115217 3342 Q R 195732187 + 32 8,3 4 2142 2.882116411 3342 G R 195732187 + 32 8,3 4 2144 2.882117647 3342 I R 195732187 + 32 8,3 4 2145 ... (1 Reply)
Discussion started by: W.C.C
1 Replies

6. Shell Programming and Scripting

Need help with this challenging code....

Hello All, I am new to this forum, and the reason I came here is to seek solution from the experts. I have written following wrapper script, it was running fine from past couple of months, until last week. When one of the function in the script which suppose to login through ssh to the... (2 Replies)
Discussion started by: tajdar
2 Replies

7. Shell Programming and Scripting

Compare files question

Hi all, How do I compare contents of entire two files except for the first line is each of them? I am sure first lines from both my files are going to be different so I want to ignore them. Is there a easier way than creating temporary files by cutting out the first line and then comparing... (1 Reply)
Discussion started by: jakSun8
1 Replies

8. Shell Programming and Scripting

Challenging!! Help needed

Hi, I have a script xyz.ksh which accpets two parameters the format of first one is :X_TABLENAME_Y and second one is a digit. I can extract a table name from that parameter and store it in a variable var_tblnm, so if i pass a parameter X_TABLE1_Y the value in var_tblenm is "TABLE1" now i have... (1 Reply)
Discussion started by: hcdiss
1 Replies

9. Filesystems, Disks and Memory

dmidecode, RAM speed = "Current Speed: Unknown"

Hello, I have a Supermicro server with a P4SCI mother board running Debian Sarge 3.1. This is the "dmidecode" output related to RAM info: RAM speed information is incomplete.. "Current Speed: Unknown", is there anyway/soft to get the speed of installed RAM modules? thanks!! Regards :)... (0 Replies)
Discussion started by: Santi
0 Replies

10. UNIX for Advanced & Expert Users

Very Challenging Question! Need help bad!

I am in desperate need of an answer to this question. I have looked everywhere (even the man pages) and found very little. Solaris has the concept of "plumbing" a network interface. What does this mean? I would be really greatful to whoever could help me answer this question. I am so... (1 Reply)
Discussion started by: Sparticus007
1 Replies
Login or Register to Ask a Question