Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: bash script, pattern matching + sum
Top Forums Shell Programming and Scripting bash script, pattern matching + sum Post 302210060 by Franklin52 on Monday 30th of June 2008 03:50:05 AM
Old 06-30-2008
This should summerize the fourth column based on the first 3 fields as key:

Code:
awk '{a[$1FS$2FS$3]+=$4}END{for(i in a){printf("%s %ld\n", i, a[i])}}' file

Regards
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

bash pattern matching echo *[! '/' ] doesn't work

without using ls, just using echo so purely pattern matching I can say echo */ <-- lists directories but how would I match files? surely something like *!/ or * but neither work ? it seems like there isn't much that I can put in but surely i should be able to put any ascii... (1 Reply)
Discussion started by: james hanley
1 Replies

2. Shell Programming and Scripting

Pattern matching in BASH

i have 255 files in a directory named 000po.k thru 255po.k and I want to copy all files except 3: exclude 000po.k, 166po.k,168po.k I know the long way around it copying these files, but am looking for a shorter way of doing this: my old approach: # copy 001po.k thru 009po.k to target... (3 Replies)
Discussion started by: zoo591
3 Replies

3. Shell Programming and Scripting

Pattern matching in a shell script?

I'm looking for a way to match a particular string in another string and if a match is found execute some command. I found the case statement can be used like this; case word in ) command ;; ] ... esac If my string to find is say "foo" in the string $mystring... (1 Reply)
Discussion started by: paulobrad
1 Replies

4. Shell Programming and Scripting

shell script pattern matching

Hi, I need to create a shell script through which i need to populate email addresses in email columns of database table in mysql. Let say if email contains yahoo, hotmail, gtalk than email addresses need to move in their respective columns. # !/bin/sh yim="example@yahoo.com"... (3 Replies)
Discussion started by: mirfan
3 Replies

5. Shell Programming and Scripting

Pattern matching in shell script

Hi, I am using following command to extract string from a file. String will be after last / (slash). awk -F\ / '{print $NF}' $FILE but while appending the output in file in script, it dosent work. File created but of zero size... can anyone please help `awk -F\\\/ '{print $NF}' $FILE` >... (3 Replies)
Discussion started by: Deei
3 Replies

6. UNIX for Dummies Questions & Answers

Script to list non matching files using pattern

Hi, I am trying to write a script that list down all the files that do not match the pattern My pattern will be like this "*.jpg|*.xml|*.sql". This pattern will be stored in a file. The script need to read this pattern from the file and delete the files that does not match this pattern. It... (7 Replies)
Discussion started by: meenavin
7 Replies

7. Shell Programming and Scripting

Sum of column matching pattern/string

Hi All, I have the following output file created as a result of one script called pattern_daily.log $ cat pattern_daily.log Approved|2|Wed, Oct 24, 2012 11:21:09 AM Declined|1|Wed, Oct 24, 2012 11:21:15 AM Approved|2|Wed, Oct 24, 2012 11:24:08 AM Declined|1|Wed, Oct 24, 2012 11:24:18 AM... (4 Replies)
Discussion started by: Gem_In_I
4 Replies

8. Shell Programming and Scripting

Pattern Matching in Perl script

I have a big perl script need to fix a small pattern matching inside .. I have patterns like create unique index create index The pattern matching should look for both the pattern in the same statement, The existing matching looks for only "create unique index" The exising code for this i... (6 Replies)
Discussion started by: greenworld123
6 Replies

9. Shell Programming and Scripting

Non-greedy pattern matching in shell script

Hi all, Is Perl included by default in Ubuntu? I'm trying to write a program using as few languages as possible, and since I'm using a few Perl one-liners to do non-greedy matching, it's considered another language, and this is a bad thing. Basically, I'm using a Perl one-liner to grab XML... (3 Replies)
Discussion started by: Zel2008
3 Replies

10. Shell Programming and Scripting

Bash pattern matching question

I need to check the condition of a variable before the script continues and it needs to match a specific pattern such as EPS-03-0 or PDF-02-1. The first part is a 3 or 4 letter string followed by a hyphen, then a 01,02 or 03 followed by a hyphen then a 0 or a 1. I know I could check for every... (4 Replies)
Discussion started by: stormcel
4 Replies

LEARN ABOUT DEBIAN

xsil2graphics

XSIL2GRAPHICS(1)					User Contributed Perl Documentation					  XSIL2GRAPHICS(1)

NAME

       xsil2graphics - generate scripts to load xsil output data files

SYNOPSIS

       xsil2graphics [options] <xsil_file>

DESCRIPTION

       Utility program bundled with xmds, used to generate scripts that load simulation output data into either matlab (http://www.mathworks.com)
       or scilab (http://www.scilab.org), which are then used to manipulate the results further if necessary and then to present the results
       graphically.

       Matlab

       To generate a matlab m-file, from the xsil file data_file.xsil use the command:

       bash$ xsil2graphics data_file.xsil

       or

       bash$ xsil2graphics --matlab data_file.xsil

       Then at the matlab command prompt:

       >> data_file

       Scilab

       To generate a scilab script file, from the xsil file data_file.xsil use the command:

       bash$ xsil2graphics --scilab data_file.xsil

       Then at the scilab command prompt:

       --> exec('data_file.sci')

OPTIONS

       -m, --matlab generate matlab m-file script to load data from the xsil data file (the default option)

       -s, -scilab generate scilab script file to load data from the xsil data file

       -o, --outfile <out_file> specify an alternative output script filename to the default which is the input xsil filename with the .xsil
       extension changed to either .m for the matlab m-file or .sci for the scilab script file

EXAMPLES

       bash$ xsil2graphics nlse.xsil

       Generates the output nlse.m to load the data into matlab

       bash$ xsil2graphics -m nlse.xsil

       Also generates the output nlse.m but explicitly sets matlab to be the output format

       bash$ xsil2graphics --scilab nlse.xsil

       Generates the output nlse.sci to load the data into scilab

       bash$ xsil2graphics --outfile nlse_new.m nlse.xsil

       Generates the output nlse_new.m to load the data into matlab

AUTHORS

       Originally written by Greg Collecutt

       Maintained by Paul Cochrane with code contributed by Joe Hope

BUGS

       No known bugs.

SEE ALSO

       xmds(1), loadxsil(1)

       http://www.xmds.org

COPYRIGHT

       Copyright (C) 2000-2004

       Code contributed by Greg Collecutt, Joseph Hope and Paul Cochrane

       This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
       CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
       Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

perl v5.8.2							    2004-06-21							  XSIL2GRAPHICS(1)
All times are GMT -4. The time now is 06:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy