Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk solution
Top Forums Shell Programming and Scripting Awk solution Post 302406378 by TonyFullerMalv on Monday 22nd of March 2010 05:51:57 PM
Old 03-22-2010
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?
 

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... (7 Replies)
Discussion started by: timj123
7 Replies

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 Replies)
Discussion started by: maxoff
3 Replies

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... (7 Replies)
Discussion started by: nikhil jain
7 Replies

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 Replies)
Discussion started by: kshitij
5 Replies

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 ... (2 Replies)
Discussion started by: torchij
2 Replies

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... (3 Replies)
Discussion started by: Raghuram717
3 Replies

LEARN ABOUT CENTOS

date::manip::configfile

Date::Manip::ConfigFile(3)				User Contributed Perl Documentation				Date::Manip::ConfigFile(3)

NAME

       Date::Manip::ConfigFile - sample config file

DESCRIPTION

       Date::Manip is a highly configurable module.  Many of the options can be set in a config file.  This document includes a sample config
       file.

       The config file consists of three sections.  The first section is config variables.  This is described more fully in the
       Date::Manip::Config document.

       The second section is the holiday definition section.  The third section is the event definition section.  These are both described more
       fully in the Date::Manip::Holidays document.

SAMPLE CONFIG FILE

       The sample config file below works for newer versions of Date::Manip.  Some of the config variables may change, or be deprecated, and some
       may not work with earlier versions of Date::Manip, so it is strongly suggested that you check out the documentation for the version of
       Date::Manip you are using to confirm any of the config variables you want to include.

	 ################################
	 # CONFIG VARIABLES
	 ################################
	 # See Date::Manip::Config man page for a description of all
	 # config variables.

	 # To include configuration information from additional
	 # config files:

	 ConfigFile		 = /path/to/another/config/file
	 ConfigFile		 = /path/to/another/config/file2

	 # For handling other languages

	 Language		 = English
	 DateFormat		 = US
	 Encoding		 =

	 # Set the current timezone:

	 SetDate		 = now,America/New_York

	 # Set the work work

	 WorkWeekBeg		 = 1
	 WorkWeekEnd		 = 5
	 WorkDay24Hr		 = 0
	 WorkDayBeg		 = 08:00
	 WorkDayEnd		 = 17:00
	 TomorrowFirst		 = 1

	 # Misc. variables

	 YYtoYYYY		 = 89
	 FirstDay		 = 1
	 Jan1Week1		 = 0
	 Printable		 = 0
	 DefaultTime		 = midnight
	 RecurRange		 = none

	 ################################
	 # HOLIDAYS
	 ################################
	 # See the Date::Manip::Holidays man page for a description of
	 # this section.
	 *HOLIDAYS

	 # FEDERAL HOLIDAYS
	 ##################

	 # You can express New Year's Day as the actual day (Jan 1)
	 # or the observed day (Jan 1 or the nearest week day).
	 # You can't include BOTH because once a day is marked as
	 # a holiday, a second definition will treat it the same
	 # as a weekend and choose another day to assign the holiday
	 # to (so there would be two days designated as New Years).

	 # Jan 1			 = New Year's Day
	 1*1:0:1:0:0:0*DWD		 = New Year's Day (observed)

	 # Two different ways to defined MLK day

	 third Monday in Jan		 = Martin Luther King Jr.'s Birthday
	 # 1*1:3:1:0:0:0		 = Martin Luther King Jr.'s Birthday

	 # Observed by federal employees in Washington D.C.

	 # Jan 20			 = Inauguration day
	 third Monday in Feb		 = Washington's Birthday
	 last Monday in May		 = Memorial Day
	 1st Monday in Sep		 = Labor Day
	 second Monday in Oct		 = Columbus Day

	 # Jul 4			 = Independence Day
	 1*7:0:4:0:0:0*DWD		 = Independence Day

	 # 11/11			 = Veterans Day
	 1*11:0:11:0:0:0*DWD		 = Veteran's Day

	 # To define both Thanksgiving and the day after, use the
	 # following two lines:

	 fourth Thu in Nov		 = Thanksgiving
	 1*11:4:4:0:0:0*FD1		 = Day after Thanksgiving

	 # Dec 25			 = Christmas
	 1*12:0:25:0:0:0*DWD		 = Christmas

	 # SAMPLE HOLIDAYS
	 ##################

	 # You can define a one-time-only holiday by specifying
	 # the day and year.

	 6/2/1999			 = A special test holiday for 1999

	 ################################
	 # EVENTS
	 ################################
	 # See the Date::Manip::Holidays man page for a description of
	 # this section.
	 *EVENTS

	 2000-02-01		  = Event01
	 2000-02-01-12:00:00	  = Event02
	 02-01			  = Event03
	 02-01 12:00:00 	  = Event04
	 1*2:0:3:13:00:00	  = Event05

	 2000-02-05 10:00:00 ; 2000-02-05 10:59:59 = Event06
	 2000-02-05	     ; 2000-02-06	   = Event07
	 02-05		     ; 02-06		   = Event08

	 2000-02-07 10:00:00 ; 0:0:0:0:3:0:0	   = Event09
	 02-07 10:00:00      ; 0:0:0:0:4:0:0	   = Event10
	 1*2:0:7:10:00:00    ; 0:0:0:0:5:0:0	   = Event11

SEE ALSO

       Date::Manip	  - main module documentation

LICENSE

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

AUTHOR

       Sullivan Beck (sbeck@cpan.org)

perl v5.16.3							    2014-06-09						Date::Manip::ConfigFile(3)
All times are GMT -4. The time now is 03:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy