Sponsored Content
Full Discussion: awk question
Operating Systems HP-UX awk question Post 98157 by isingh786 on Monday 6th of February 2006 03:24:38 PM
Old 02-06-2006
awk question

Hi,

I have a awk script which takes the input as dat file and generates doc file as output. This script is running fine for long time. But lately users are complaining about one problem. If there are multiple parts number it should display the information by part numbers.
like this:

Code:
ORDER #:15WZ0000	Part #:15117110		Model Y.:6   Recv. Dock:DDD   ST Loc.:18003
.......................................................................................
ORDER #:15WZ0006	Part #:15856412		Model Y.:6   Recv. Dock:DDD   ST Loc.:18003

Previous Cumm. Quantity:0		Horizon Start:20051225	Horizon End:20060204
Cumulative Quantity    :0		Horizon Start:20051225	Dispatch Date:20060205


FORECAST           PERIOD    DATE REQUIRED               QUANTITY
======================================================================
Firm                Weekly   20060206                           810
Firm                Weekly   20060213                           542
======================== End of the Item 15856412 =======================
Firm                Weekly   20060305                           105
Planning            Weekly   20060213                           840
Planning            Weekly   20060220                          1170
Planning            Weekly   20060227                          1200
Planning            Weekly   20060306                          1740
Planning            Weekly   20060313                          1110
Planning            Weekly   20060320                          1155
Planning            Weekly   20060327                           825
Planning            Weekly   20060410                           690
Planning            Weekly   20060417                           930
Planning            Weekly   20060424                          1365
Planning            Weekly   20060501                          1365
Planning            Weekly   20060508                          1215
Planning            Weekly   20060515                          1035
Planning            Weekly   20060522                           855

As you can see there are two part number and after the first part number it displays a line that has the data saying "end of item".

It works fine when there are multiple part numbers in one file. But, If I have multiple files then it shows the correct information for 1st part but not for other parts like part level information.

In my second post, I am uploading the script which are using to generate this report.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk question

I have the following error: ls -lt | awk 'BEGIN NR > 1 { print $2, $9 }' Syntax Error The source line is 1. The error context is BEGIN >>> NR <<< > 1 { print $2, $9 } awk: 0602-500 Quitting The source line is 1. What I want to do is ls a directory, skip the first... (3 Replies)
Discussion started by: lesstjm
3 Replies

2. Shell Programming and Scripting

One more awk question!

Hello, I have the following command that does 2 searches. awk '{if ($0 ~ /STRING1/) {c++} }{if ( c == 2 ) {sub(/STRING1/,"NEWSTRING") } } { print }' FILE How do I search up after the first search? thanks (4 Replies)
Discussion started by: ctcuser
4 Replies

3. Shell Programming and Scripting

awk .. question?

i have a little awk script that I use looks this: awk '{if (FNR==1){print FILENAME; print $0}else print $0}' file1...file2....fi... > bundled. i have completely forgotten how to unbundle this. I have tried several different approaches and still can not remember how to unbundle the file bundled.... (2 Replies)
Discussion started by: moxxx68
2 Replies

4. Shell Programming and Scripting

awk question

I am trying to read through a file, gather the states in that file and change it from an abbreviation to the ful text. Can anyone provide some assistance. Thanks!! (4 Replies)
Discussion started by: cnitadesigner
4 Replies

5. Shell Programming and Scripting

Awk Question

How I can rid of the following presentation du -sk /u*/oradata/TEST/*.dbf |awk '{print total+=$1} 1.28003e+06 4.35109e+06 4.36134e+06 4.4535e+06 5.47752e+06 5.48777e+06 7.52554e+06 7.73036e+06 9.06158e+06 :confused: thank you (3 Replies)
Discussion started by: zam
3 Replies

6. UNIX for Dummies Questions & Answers

awk question

Hi, in the following script, what does " a=$0} END " mean ? do we need that ? Thanks awk '{a=$0} END {for (i=NR; i>=1; i--) print a}' file (3 Replies)
Discussion started by: james94538
3 Replies

7. UNIX for Dummies Questions & Answers

awk question

Can anyone help with this this one liner: nawk -v RS='' '$1=$1' InputFile What I have in the file: 0.0013985457223116 -0.0002338180925628 0.0 0.0003709430584958 -0.0005763523138347 0.0 And the output I want: 0.0013985457223116 -0.0002338180925628 0.0 0.0003709430584958... (1 Reply)
Discussion started by: mookie123
1 Replies

8. UNIX for Dummies Questions & Answers

Basic awk question...getting awk to act on $1 of the command itself

I have a script problem that I am not able to solve due my very limited understanding of unix/awk. This is the contents of test.sh awk '{print $1}' From the prompt if I enter: ./test.sh Hello World I would expect to see "Hello" but all I get is a blank line. Only then if I enter "Hello... (2 Replies)
Discussion started by: JasonHamm
2 Replies

9. Homework & Coursework Questions

awk question.

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: im using ls -l | xargs | awk '{what ever files here}' im trying to get something that looks like this... (7 Replies)
Discussion started by: rontopia
7 Replies

10. Shell Programming and Scripting

awk question : system output to awk variable.

Hi Experts, I am trying to get system output to capture inside awk , but not working: Please advise if this is possible : I am trying something like this but not working, the output is coming wrong: echo "" | awk '{d=system ("date") ; print "Current date is:" , d }' Thanks, (5 Replies)
Discussion started by: rveri
5 Replies
CFETOOLINFO(8)						User Contributed Perl Documentation					    CFETOOLINFO(8)

NAME
cfetoolinfo - Get information about a database SYNOPSIS
cfetool info name [--path|-p directory name] [--daily|-d] [--weekly|-w] [--yearly|-y] [--verbose|-v] [--help|-h] DESCRIPTION
Prints out some basic information about the specified database, including: the location of the database, the location of the histogram file (if there is one), the step interval, the database age, the time it was last updated, and the current overall average and variation. OPTIONS
--path|-p directory name The directory in which to find the database folder. If this argument is not provided, the current working directory will be assumed. --daily|-d Provide information about the daily averages database. --weekly|-w Provide information about the weekly averages database. --yearly|-y Provide information about the yearly averages database. --verbose|-v Print details of the command's execution to the standard output stream. --help|-h Prints a short help message and then exits. EXAMPLE
% cfetool info temperature --path /my/path Weekly average database: Database Location: /my/path/temperature/weekly.db Histogram file: /my/path/temperature/weekly.hist Step: 10 minutes Database Age: 0.000992 weeks (1 steps) Last update: Mon Sep 13 16:20:40 2004 (1095117640) Current average: 7.105000, Var: 38.280217 AUTHORS
The code and documentation were contributed by Stanford Linear Accelerator Center, a department of Stanford University. This documentation was written by Elizabeth Cassell <e_a_c@mailsnare.net> and Alf Wachsmann <alfw@slac.stanford.edu> COPYRIGHT AND DISCLAIMER
Copyright 2004 Alf Wachsmann <alfw@slac.stanford.edu> and Elizabeth Cassell <e_a_c@mailsnare.net> All rights reserved. perl v5.8.4 2004-09-21 CFETOOLINFO(8)
All times are GMT -4. The time now is 03:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy