Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Pass an array to awk to sequentially look for a list of items in a file
Top Forums Shell Programming and Scripting Pass an array to awk to sequentially look for a list of items in a file Post 303033660 by Don Cragun on Wednesday 10th of April 2019 04:39:30 AM
Old 04-10-2019
In post #1, the labels in your sample input files were "train statistics" and "test statistics". In your latest code you have labels with underscores instead of spaces. You'll have to be sure your stats files and your labels match.

In post #3, you included a header line in your output; I don't see anything in your latest code that prints that header. And, unless each of your stats files contains all of the sets of statistics and includes them in the same order, what you have shown us will end up printing data for different sets of statistics under each other in the output with no indication of which set they came from. Do each of your stats files contain statistics from all of the possible sets of statistics and are each of those sets of statistics present in the same order in each stats file?

In your latest code you have:
Code:
# name of file being processed
STATS_FILE=$1
# file we are writing to
LOGFILE=$1

which sets both your input file and your output file to be the same input parameter. I'm about 99% sure that isn't what you want.

The cat in your code isn't helping and seems to be working against you. I think you're going to want to end up with something more like:
Code:
... ... ...

# file we are writing to
LOGFILE=$1
# The rest of the operands are stats files we need to read.
shift

awk -v labels="$LABELS" '
    ... ... ...
' "$@" > "$LOGFILE"

Do you want your output fields to be tab separated, or do you want your output fields to be in aligned columns? Note that since your field headers vary in width from 6 characters (e.g., "test_n" to more than 9 characters (e.g. " train_MdAE" and your statistics data all fit in less than 8 characters, the two choices are mutually exclusive. (I.e., you can't have both.)
This User Gave Thanks to Don Cragun For This Post:
LMHmedchem
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pass array variabel to awk from shell

Hi I need to pass an array to Awk script from Shell. Can you please tell how to do it? How to pass this array add_ct_arr to an awk script or access it in awk? i=1 while ; do add_ct_arr=$(echo ${adda_count} | awk -v i=$i -F" " '{print $i;}') echo ${add_ct_arr} ... (1 Reply)
Discussion started by: appsguy616
1 Replies

2. Shell Programming and Scripting

hw to insert array values sequentially in a file

Hi All :), I am very new to unix. I am requiring ur help in developing shell script for below problem. I have to replace the second field of file with values of array sequentially where first field is ValidateKeepVar <File> UT-ExtractField 1 | &LogEntry &Keep(DatatoValidate)... (3 Replies)
Discussion started by: rohiiit.sharma
3 Replies

3. Shell Programming and Scripting

awk between items including items

OS=HP-UX ksh The following works, except I want to include the <start> and <end> in the output. awk -F '<start>' 'BEGIN{RS="<end>"; OFS="\n"; ORS=""} {print $2} somefile.log' The following work in bash but not in ksh sed -n '/^<start>/,/^<end>/{/LABEL$/!p}' somefile.log (4 Replies)
Discussion started by: Ikon
4 Replies

4. Shell Programming and Scripting

Pass awk array variable to shell

Hi, all suppose I have following myfile (delimited by tab) aa bb cc dd ee ffand I have following awk command: awk 'BEGIN{FS="\t"}{AwkArrayVar_1=$1;AwkArrayVar_2=$2};END{for(i=0; i<NR; i++) print i, AwkArrayVar_1, AwkArrayVar_2,}' myfileMy question is: how can I assign the awk array... (7 Replies)
Discussion started by: littlewenwen
7 Replies

5. Shell Programming and Scripting

[Solved] awk command to read sequentially from a file until last record

Hello, I have a file that looks like this: Generated geometry (...some special descriptor) 1 0.56784 1.45783 -0.87965 8 1.29873 -0.8767 1.098789 ... ... ... ... Generated geometry (....come special descriptor) ... .... ... ... ... ... ... ... and... (4 Replies)
Discussion started by: jaldo0805
4 Replies

6. Shell Programming and Scripting

How to pass an array containing file names to a sftp script?

hi, i want to pass an array parameters to a sftp script so that i can transfer each file in the array to the remote server by connecting only once to the sftp remote server. i thought of using a variable that contains list of file names separated by a space and pass the variable to the sftp... (3 Replies)
Discussion started by: Little
3 Replies

7. Shell Programming and Scripting

Split list of files into an array and pass to function

There are two parts to this. In the first part I need to read a list of files from a directory and split it into 4 arrays. I have done that with the following code, # collect list of file names STATS_INPUT_FILENAMES=($(ls './'$SET'/'$FOLD'/'*'in.txt')) # get number of files... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

8. Shell Programming and Scripting

sed to delete items in an array from a file

I need to create a shell script to delete multiple items (Strings) at a time from a file. I need to iterate through a list of strings. My plan is to create an array and then iterate through the array. My code is not working #!/bin/bash -x declare -a array=(one, two, three, four)... (5 Replies)
Discussion started by: bash_in_my_head
5 Replies

9. Shell Programming and Scripting

Read a lis, find items in a file from the list, change each item

Hello, I have some tab delimited text data, file: final_temp1 aname val NAME;r'(1,) 3.28584 r'(2,)<tab> NAME;r'(3,) 6.13003 NAME;r'(4,) 4.18037 r'(5,)<tab> You can see that the data is incomplete in some cases. There is a trailing tab after the first column for each incomplete row. I... (2 Replies)
Discussion started by: LMHmedchem
2 Replies

10. Shell Programming and Scripting

Script to process a list of items and uncomment lines with that item in a second file

Hello, I have a src code file where I need to uncomment many lines. The lines I need to uncomment look like, C CALL l_r(DESNAME,DESOUT, 'Gmax', ESH(10), NO_APP, JJ) The comment is the "C" in the first column. This needs to be deleted so that there are 6 spaces preceding "CALL".... (7 Replies)
Discussion started by: LMHmedchem
7 Replies

LEARN ABOUT HPUX

mailstats

mailstats(1)						      General Commands Manual						      mailstats(1)

NAME

       mailstats - print mail traffic statistics

SYNOPSIS

       cffile] stfile]

DESCRIPTION

       reads  and  interprets  the  statistics	file,  and then prints out the mail traffic statistics.  The statistics file is the one set by the
       option in the The default statistics file is If the statistics file exists, collects statistics about your mail traffic and stores them	in
       that file.  This file does not grow.

       Statistics are gathered on a per-mailer basis for each mailer defined in the configuration file.  Statistics are kept on the number of mes-
       sages and the number of bytes for all inbound and outbound traffic.

       The utility displays the time at which statistics collection was started on the first line.  Then, the statistics of each  mailer  is  dis-
       played on a single line, each with the following white space separated fields (see the "EXAMPLES" section below):

       The mailer number.

       Number of messages from the mailer.

       Kbytes from the mailer.

       Number of messages to the mailer.

       Kbytes to the mailer.

       Number of messages rejected.

       Number of messages discarded.

       The name of the mailer.

       After  this display, a line totaling the values for all of the mailers is displayed, separated from the previous information by a line con-
       taining only equals (``='') characters.

   Note
       can be used by privileged users only.

   Options
       The options are as follows:

       Read the specified
		   cffile instead of the default file.

       Read the specified statistics file,
		   stfile, instead of the statistics file specified in the file.

       Do not display the name of the mailer in the output.

       Output information  in  program-readable  mode  and clear statistics.

       To clear the statistics file, execute, as root:

RETURN VALUE

       The utility exits with 0 on success, and >0 if an error occurs.

DIAGNOSTICS

       generates error messages if the statistics file is not accessible or if the size of the statistics file has changed.  Error messages are:

	      Either statistics-file is zero length, meaning that no mail has been transferred since it was cleared out, or its size has  changed.
		     Since the size of this file is supposed to remain constant, any change in size means that the file is invalid.

	      The statistics file does not exist.

	      The statistics file's permissions are set so that you cannot read it.

EXAMPLES

       Here is a typical example of output:

	      =============================================================

       This example shows that mailers 0, 3 and 5 have handled the given amounts of mail traffic since Thursday, Jul 11th.  Specifically, has sent
       11 messages containing 11 kilobytes via mailer esmtp (M 5), but has 4 messages rejected via mailer esmtp (M 5).

AUTHOR

       was developed by the University of California, Berkeley.

FILES

       default mail traffic statistics file
       sendmail configuration file

SEE ALSO

       sendmail(1M).

																      mailstats(1)
All times are GMT -4. The time now is 02:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy