Awk solution Post: 302406378

Sponsored Content

Top Forums Shell Programming and Scripting Awk solution Post 302406378 by TonyFullerMalv on Monday 22nd of March 2010 05:51:57 PM

03-22-2010

Registered User

Does it have to be in awk(1)?

Here is a shell script that would do the trick:

Code:

$ cat file_order_number_test.sh
#!/bin/bash
while read ORDERNUMBER; do
  grep "^${ORDERNUMBER}" file1-order-data-file
done < file2-order-numbers
$

Here are example data files:

Code:

$ cat file1-order-data-file 
number, cust., part, qty, date 
0001, BAE Systems, wing, 1, 20th Dec. 2000
0002, BA, In Flight Lunches, 20, 21st Dec. 2000
0003, Boots The Chemist, Aspirin 500mg, 1000, 22nd Dec. 2000
0004, Cadbury, Full Fat Milk, 10000, 23rd Dec. 2000
0005, Woolworths, A4 Photocopy Paper, 144, 27th Dec. 2000
0006, Marks and Spencer, Cotton Y-Fronts, 2000, 28th Dec. 2000
0007, Goldburg Jewellers, Gold Bullion, 10, 29th Dec. 2000
$

Code:

$ cat file2-order-numbers 
0001
0003
0005
0007

Here is a test run:

Code:

$ ./file_order_number_test.sh
0001, BAE Systems, wing, 1, 20th Dec. 2000
0003, Boots The Chemist, Aspirin 500mg, 1000, 22nd Dec. 2000
0005, Woolworths, A4 Photocopy Paper, 144, 27th Dec. 2000
0007, Goldburg Jewellers, Gold Bullion, 10, 29th Dec. 2000

Is that any good to you?

TonyFullerMalv

View Public Profile for TonyFullerMalv

Find all posts by TonyFullerMalv

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is there a awk solution for this??

I am writing a awk script that gathers certain data from certain fields. I needed a awk solution for this, because it will later become a function in the script. I have the following data that I need output on a single line, but record spans across multilple lines and records are not...

2. Shell Programming and Scripting

AWK or SED solution

Hello. I have big file data like this(part of file): .... 18210102021010000110 47401000000 021001 5166891.16 021011 5166891.16 18210602010020000110 47401000000 020701 8995421.00 021001 8995421.00 021011 8995421.00 030801 .08 18210604011020000110 47401000000 020701 9048.00 021001...

3. Shell Programming and Scripting

Any solution with awk for volatile columns??

Hi I have this file with content ale,4 ,ale,2 ,ale,1 ,ale,2 ale,1 ,ale,7 ,ale,7 ,ale,13 ale,6 ,ale,1 ,ale,1 ,ale,1 ale,1 ,ale,1 ,ale,37 ,ale,1 ale,1 ,ale,1 ,ale,2 ,ale,37 ale,77 ,ale,1 ,ale,53 ,ale,3 ale,5 ,ale,1 ,ale,2 ,ale,40 ale,1 ,ale,1 ,ale,44 ,ale,1...

4. Shell Programming and Scripting

sed or awk Solution

Hi I am having a csv file like this ahsh,90.82,add,32424,ahha hhdh,98.89,hdhdh,92728,neha hshs,you,97.7,hdhdhd,are,a jsjsj,wonderful,9788,79.9,aheh ahdh,95.5,girl, 2737,jolllI need to add width="100" to the value which is greater than 90 like decimal points but less than 100 Output...

5. UNIX for Dummies Questions & Answers

Help with awk solution to add columns

Hi all. Wondering if someone can help with an awk solution to a problem I'm stumped with. I have a matrix file with >1000 fields and would like to add another column after each column with a text label. For example: Input: $cat file.txt name col1 col2 col3 coln aaaa ...

6. UNIX for Beginners Questions & Answers

awk solution for Splitting a file.

Hi I have a csv file with as below sdg-catalog-00000001 sdg-sku-00000317 sdg-sku-00000318 sdg-sku-00000319 sdg-sku-00000320 sdg-catalog-00000002 sdg-sku-00000321 sdg-sku-00000322 sdg-sku-00000323 sdg-sku-00000324 sdg-sku-00000325 sdg-catalog-00000003 sdg-sku-00000326...

LEARN ABOUT CENTOS

lwres_herror

LWRES_HSTRERROR(3)						       BIND9							LWRES_HSTRERROR(3)

NAME

       lwres_herror, lwres_hstrerror - lightweight resolver error message generation

SYNOPSIS

       #include <lwres/netdb.h>

       void lwres_herror(const char *s);

       const char * lwres_hstrerror(int err);

DESCRIPTION

       lwres_herror() prints the string s on stderr followed by the string generated by lwres_hstrerror() for the error code stored in the global
       variable lwres_h_errno.

       lwres_hstrerror() returns an appropriate string for the error code gievn by err. The values of the error codes and messages are as follows:

       NETDB_SUCCESS
	   Resolver Error 0 (no error)

       HOST_NOT_FOUND
	   Unknown host

       TRY_AGAIN
	   Host name lookup failure

       NO_RECOVERY
	   Unknown server error

       NO_DATA
	   No address associated with name

RETURN VALUES

       The string Unknown resolver error is returned by lwres_hstrerror() when the value of lwres_h_errno is not a valid error code.

SEE ALSO

       herror(3), lwres_hstrerror(3).

COPYRIGHT

       Copyright (C) 2004, 2005, 2007 Internet Systems Consortium, Inc. ("ISC")
       Copyright (C) 2000, 2001 Internet Software Consortium.

BIND9								   Jun 30, 2000 						LWRES_HSTRERROR(3)

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is there a awk solution for this??

Discussion started by: timj123

2. Shell Programming and Scripting

AWK or SED solution

Discussion started by: maxoff

3. Shell Programming and Scripting

Any solution with awk for volatile columns??

Discussion started by: nikhil jain

4. Shell Programming and Scripting

sed or awk Solution

Discussion started by: kshitij

5. UNIX for Dummies Questions & Answers

Help with awk solution to add columns

Discussion started by: torchij

6. UNIX for Beginners Questions & Answers

awk solution for Splitting a file.

Discussion started by: Raghuram717

LEARN ABOUT CENTOS

lwres_herror