ksh passing to awk multiple dyanamic variables awk -v Post: 302706979

Sponsored Content

Top Forums Shell Programming and Scripting ksh passing to awk multiple dyanamic variables awk -v Post 302706979 by highnthemnts on Thursday 27th of September 2012 08:08:00 PM

09-27-2012

Registered User

ksh passing to awk multiple dyanamic variables awk -v

Using ksh to call a function which has awk script embedded.
It parses a long two element list file, filled with text numbers (I want column 2, beginning no sooner than line 45, that's the only known thing) . It's unknown where to start or end the data collection, dynamic variables will be used.
ie, scan lines 45 - 20000 first pass. second pass, scan lines 104-1065,third pass scan 742-5954...

The script returns some maths: (max, min, and ::: not yet there: line numbers of max, min, block average). There are ~10,000 files to examine. would like to pass this back into an array or list variable

the $item file looks like this:
123456788,-111.2316547
123456789,-25.1234579
...

Problem: it needs to search run-time defined blocks of the file, ie, between lines r and j. I can't quite get this part to work:

it uses -v to capture the variables: awk -v rstart=$r -v jend
and tries to block it off this way: if ((NR >= $rstart) && (NR <= $jend)

Good news, the awk works if you: if ((NR >= 45) && (NR <= 1000))

Secondary issue: have the results populate an array or list that i can work with later in ksh.

Code:

function return_minmax_r_j
 {
 awk -v rstart=$r -v jend=$j 'function  max(x){i=-999;for(val in x){if(i<=x[val]){i=x[val];}}return  i;}function min(x){i=max(x);for(val in  x){if(i>x[val]){i=x[val];}}return i;}{FS=","}{if ((NR >= $rstart)  && (NR <= $jend))  a[$2]=$2;next}END{minimum=min(a);maximum=max(a);  print maximum minimum}' $item 
 }

Code:

#===MAIN===
 generate_file_name_array  #generates a list of file names

 for item in ${FILE_LIST_ARRAY[@]} 
                do 
                r=45
                j=2000  #these will be variables declared later.

                return_minmax_r_j
                done
 return

highnthemnts

View Public Profile for highnthemnts

Find all posts by highnthemnts

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Passing Variables to AWK

Does anybody have an explanation for the following: The following scripts runs fine on IRIX64 6.5 but has bugs on Solaris 8. #! /bin/sh echo run only on an SGI machine echo type in linenumber read j echo value read value awk -f rmspass2 level=$value $j'step1.mlf' When the script is...

2. Shell Programming and Scripting

Passing Variables to Awk

Hi I have a unix shell script with an awk statement. I would like to print some of the fields of an input file. However, I would like to print them dynamically, ie by passing the literal $1 $3 into the script to define the output. I have tried the following: variable1='$1' awk...

3. Shell Programming and Scripting

Passing awk Variables

I am trying to pass the results from a variable gathered from awk, however when I echo the 'PARSE' and 'SUB', the response is blank. This is my command. awk -F= '/Unit/''{ PARSE=substr($2,1,5) ; SUB=substr($2,1,1) }' inputfile.lst Is this a kind of valid attempt or am I obligated to declare...

4. Shell Programming and Scripting

passing variables to awk from ksh script

I'm trying to write a ksh script that uses awk, but I want to pass variables to awk. For example (not working): if ];then searchstr=$1 lsof -i | awk '{if($9~/SEARCHSTR/) print $2} SEARCHSTR=$searchstr' else echo "usage: $0 <search string>" fi I tried several options. Is it...

5. Shell Programming and Scripting

awk splits file in to multiple - how to get filenames in variables withing ksh?

Hi all, I'm using awk in a .ksh script to split one file by line prefix into different files (up to 4). The files are named after the prefix in the line, and a sequence no. Is there any way to get the filenames in to variables too? I need _ftpfile1, _ftpfile2, _ftpfile3 and _ftpfile4 which are...

6. Shell Programming and Scripting

Passing awk variables to shell

Hi. I need to parse file and assign some values to variables, right now i do like below MYHOMEDIR=`awk '/Home/ {print $NF}' output.txt` MYSHELL=`awk '/Shell/ {print $NF}' output.txt` PRGRP=`awk '/Primary/ {print $NF}' output.txt` SECGRP=`awk '/Second/ {print $NF}' output.txt` In this...

7. Shell Programming and Scripting

Passing variables into AWK

I'm trying to use awk to write new entries to a hosts file if they don't exist. I need to do so depending on the type of system I have. Below is what I have, but it isn't working. awk -v myip1=$IP1 myip2=$IP2 myhost1=$HOST1 myhost2=$HOST2' BEGIN { mqhost1=0; mqhost2=0; stap1=0; stap2=0; } ...

8. Shell Programming and Scripting

Passing variables to awk

Hi guys, I need to fetch data from logfile between two given dates,i got the below code from our forum.It works perfect,but i need to enter the value dynamically to awk while running. awk '/2012 Jun/{p=1}!/2012 Jul/ && prev~/2012 Jul/ && p{p=0}{prev=$0}p' file i tried the below code,but...

9. Shell Programming and Scripting

Passing awk variables to bash variables

Trying to do so echo "111:222:333" |awk -F: '{system("export TESTO=" $2)}'But it doesn't work

10. Shell Programming and Scripting

awk - passing variables in and out

Am looking to pass some Linux environment variables into AWK , can I simply use the -v option ? awk -F: -v AHOME=$HOME '{ if {rm AHOME/file.txt a=2 } }' config.txt ...

LEARN ABOUT DEBIAN

fiaif-scan

FIAIF-SCAN(8)					      Administration and Privileged Commands					     FIAIF-SCAN(8)

NAME

       fiaif-scan - print syslog entries in human readable form

SYNOPSIS

       fiaif-scan [ -n ] [ -m ]

DESCRIPTION

       fiaif-scan  reads  lines  from  STDIN  and prints to STDOUT, in human readable form, any packets found (standard syslog format is assumed).
       Each log message is parsed based on the configuration files at the time fiaf-scan is run.  The idea is to enable the user to quickly  iden-
       tify which zone rule is causing the packet to be logged, and how to change this, if necessary.

OPTIONS

       -n     Don't  do a reverse lookup of IP addresses or ports; display them as numbers.  This reduces the number of host lookups and speeds up
	      scanning.

       -m     print the MAC address on each line.

EXAMPLE

       fiaf-scan -n </var/log/messages
	      Scan from the current system log and display any packets on the console.	Don't look up names for IP addressses or ports; just  show
	      the numbers.

FILES

       /etc/fiaif/fiaif.conf

AUTHOR

       Anders Fugmann <anders(at)fugmann.net>

BUGS

       The program has been tested only with messages from the standard syslog. It may work on lines from ulogd, but this has not been tested.

       Bash  may  not  be  the	fastest  parser  in  the  world. Expect this software to be slow. (40 lines per sec on a K6-II/300Mhz without name
       lookups).

       Please report other bugs to <fiaif@fiaif.net>.

SEE ALSO

       fiaif.conf(5), zone.conf(5), iptables(8), syslog(3)

Linux								     Feb 2003							     FIAIF-SCAN(8)