Hi comunity, its my first thread. I'm working in a script for sort a lot data of next way:
Code:
ID MINUTE TIME
SA 17:21:34 507
SB 17:22:04 484
ST 17:24:49 431
SB 17:28:16 546
SA 17:28:35 304
SA 17:29:24 437
SY 17:36:45 521
SX 17:38:47 277
SX 17:38:59 517
SB 17:42:57 249
ST 17:43:25 587
SY 17:44:51 575
ST 17:49:31 624
and i'm specting the result be sort the total ids "S'X'" printing the totals in, them take the average of time for every ID, the max time , the less time. i.e:
Code:
ID TOTAL AVERAGE MAX-TIME MIN-TIME
SA 3 430 507 304
SB 3 470 546 249
ST 3 521 624 431
SX 2 393 517 277
SY 2 543 575 521
I was looking for the before opened threads but at moment i didn't this work. I will greatest for any help!
Hi guys
I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file.
#!/bin/sh
echo " $2 $3 $4 $5 $6 $7
isql -w400 -U$2 -S$5 -P$3 << xxx
use $4
go
print"**Changes to the table... (0 Replies)
Hello,
I have this awk script that I want to execute by passing parameters through a shell script.
I'm a little confused. This awk script removes duplicates from an input file.
Ok, so I have a .sh file called rem_dups.sh
#!/usr/bin/sh... (4 Replies)
hi everyone
i am trying to do this
bash> cat abc.sh
deepak()
{
echo Deepak
}
deepak
bash>./abc.sh
Deepak
so it is giving me write simply i created a func and it worked
now i modified it like this way
bash> cat abc.sh (2 Replies)
This is the final first release of the dynamic menu generator for pekwm (WM).
#!/bin/bash
function param_val {
awk "/^${1}=/{gsub(/^${1}="'/,""); print; exit}' $2
}
echo "Dynamic {"
for CF in `ls -c1 /usr/share/applications/*.desktop`
do
name=$(param_val Name $CF)
... (3 Replies)
I am getting the following error while passing parameter to a shell script called within awk script. Any idea what's causing this issue and how to ix it ? Thanks
sh: -c: line 0: syntax error near unexpected token `newline'
sh: -c: line 0: `./billdatecalc.sh ... (10 Replies)
Discussion started by: Sudhakar333
10 Replies
7. Post Here to Contact Site Administrators and Moderators
Variable I have in my shell script
diff=$1$2.diff
id=$2
new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new
I could see value of $id is not passing to the awk... (0 Replies)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff |... (1 Reply)
Hi
I have a text file (Input.txt) with two column entries separated by tab as given below:
aaa str1
bbb str2
cccccc str3
dddd str4
eee str3
ssss str2
sdf str3
hhh str1
fff str2
ccc str3
.....
.....
..... (1 Reply)
I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Discussion started by: Eric7giants
1 Replies
LEARN ABOUT DEBIAN
funcolumnactivate
funcolumnactivate(3) SAORD Documentation funcolumnactivate(3)NAME
FunColumnActivate - activate Funtools columns
SYNOPSIS
#include <funtools.h>
void FunColumnActivate(Fun fun, char *s, char *plist)
DESCRIPTION
The FunColumnActivate() routine determines which columns (set up by FunColumnSelect()) ultimately will be read and/or written. By default,
all columns that are selected using FunColumnSelect() are activated. The FunColumnActivate() routine can be used to turn off/off activa-
tion of specific columns.
The first argument is the Fun handle associated with this set of columns. The second argument is a space-delimited list of columns to
activate or de-activate. Columns preceded by "+" are activated and columns preceded by a "-" are de-activated. If a column is named with-
out "+" or "-", it is activated. The reserved strings "$region" and '$n' are used to activate a special columns containing the filter
region value and row value, respectively, associated with this row. For example, if a filter containing two circular regions is specified
as part of the Funtools file name, this column will contain a value of 1 or 2, depending on which region that row was in. The reserved
strings "$x" and "$y" are used to activate the current binning columns. Thus, if the columns DX and DY are specified as binning columns:
[sh $] fundisp foo.fits[bincols=(DX,DY)]
then "$x" and "$y" will refer to these columns in a call to FunColumnActivate().
In addition, if the activation string contains only columns to be activated, then the routine will de-activate all other columns. Simi-
larly, if the activation string contains only columns to de-activate, then the routine will activate all other columns before activating
the list. This makes it simple to change the activation state of all columns without having to know all of the column names. For example:
o "pi pha time" # only these three columns will be active
o "-pi -pha -time" # all but these columns will be active
o "pi -pha" # only pi is active, pha is not, others are not
o "+pi -pha" # same as above
o "pi -pha -time" # only pi is active, all others are not
o "pi pha" # pha and pi are active, all others are not
o "pi pha -x -y" # pha and pi are active, all others are not
You can use the column activation list to reorder columns, since columns are output in the order specified. For example:
# default output order
fundisp snr.ev'[cir 512 512 .1]'
X Y PHA PI TIME DX DY
-------- -------- -------- -------- --------------------- -------- --------
512 512 6 7 79493997.45854475 578 574
512 512 8 9 79494575.58943175 579 573
512 512 5 6 79493631.03866175 578 575
512 512 5 5 79493290.86521725 578 575
512 512 8 9 79493432.00990875 579 573
# re-order the output by specifying explicit order
fundisp snr.ev'[cir 512 512 .1]' "time x y dy dx pi pha"
TIME X Y DY DX PI PHA
--------------------- -------- -------- -------- -------- -------- --------
79493997.45854475 512 512 574 578 7 6
79494575.58943175 512 512 573 579 9 8
79493631.03866175 512 512 575 578 6 5
79493290.86521725 512 512 575 578 5 5
79493432.00990875 512 512 573 579 9 8
A "+" sign by itself means to activate all columns, so that you can reorder just a few columns without specifying all of them:
# reorder 3 columns and then output the rest
fundisp snr.ev'[cir 512 512 .1]' "time pi pha +"
TIME PI PHA Y X DX DY
--------------------- -------- -------- -------- -------- -------- --------
79493997.45854475 7 6 512 512 578 574
79494575.58943175 9 8 512 512 579 573
79493631.03866175 6 5 512 512 578 575
79493290.86521725 5 5 512 512 578 575
79493432.00990875 9 8 512 512 579 573
The column activation/deactivation is performed in the order of the specified column arguments. This means you can mix "+", "-" (which de-
activates all columns) and specific column names to reorder and select columns in one command. For example, consider the following:
# reorder and de-activate
fundisp snr.ev'[cir 512 512 .1]' "time pi pha + -x -y"
TIME PI PHA DX DY
--------------------- -------- -------- -------- --------
79493997.45854475 7 6 578 574
79494575.58943175 9 8 579 573
79493631.03866175 6 5 578 575
79493290.86521725 5 5 578 575
79493432.00990875 9 8 579 573
We first activate "time", "pi", and "pha" so that they are output first. We then activate all of the other columns, and then de-activate
"x" and "y". Note that this is different from:
# probably not what you want ...
fundisp snr.ev'[cir 512 512 .1]' "time pi pha -x -y +"
TIME PI PHA Y X DX DY
--------------------- -------- -------- -------- -------- -------- --------
79493997.45854475 7 6 512 512 578 574
79494575.58943175 9 8 512 512 579 573
79493631.03866175 6 5 512 512 578 575
79493290.86521725 5 5 512 512 578 575
79493432.00990875 9 8 512 512 579 573
Here, "x" and "y" are de-activated, but then all columns including "x" and "y" are again re-activated.
Typically, FunColumnActivate() uses a list of columns that are passed into the program from the command line. For example, the code for
funtable contains the following:
char *cols=NULL;
/* open the input FITS file */
if( !(fun = FunOpen(argv[1], "rc", NULL)) )
gerror(stderr, "could not FunOpen input file: %s
", argv[1]);
/* set active flag for specified columns */
if( argc >= 4 ) cols = argv[3];
FunColumnActivate(fun, cols, NULL);
The FunOpen() call sets the default columns to be all columns in the input file. The FunColumnActivate() call then allows the user to con-
trol which columns ultimately will be activated (i.e., in this case, written to the new file). For example:
funtable test.ev foo.ev "pi pha time"
will process only the three columns mentioned, while:
funtable test.ev foo.ev "-time"
will process all columns except "time".
If FunColumnActivate() is called with a null string, then the environment variable FUN_COLUMNS will be used to provide a global value, if
present. This is the reason why we call the routine even if no columns are specified on the command line (see example above), instead of
calling it this way:
/* set active flag for specified columns */
if( argc >= 4 ){
FunColumnActivate(fun, argv[3], NULL);
}
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funcolumnactivate(3)
04-16-2012
Help for a awk script
