Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: how can i group by same columns by another columns in Bash
Top Forums Shell Programming and Scripting how can i group by same columns by another columns in Bash Post 302500285 by Franklin52 on Monday 28th of February 2011 06:03:29 AM
Old 02-28-2011
Quote:
Originally Posted by qjlongs
Thank u very much!
these is an other problem for me,
I don't know the method of gensub' means

How can I printout the result with format "###,###,###"
The gensub function works only with gawk.
This User Gave Thanks to Franklin52 For This Post:
qjlongs
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Group by columns and get the counts

Hi Gurus, I have a file 1|usa|hh 2|usa|ll 3|usa|vg 4|usa|vg 5|usa|vg 6|usa|vg 7|usa|ll 8|uk|nn 9|uk|bb 10|uk|bb 11|kuwait|mm 12|kuwait|jkj 13|kuwait|mm 14|dubai|hh I want to group by last two columns and get the last two recs and count. (3 Replies)
Discussion started by: sumeet
3 Replies

2. Shell Programming and Scripting

Single command for add 2 columns and remove 2 columns in unix/performance tuning

Hi all, I have created a script which adding two columns and removing two columns for all files. Filename: Cust_information_1200_201010.txt Source Data: "1","Cust information","123","106001","street","1-203 high street" "1","Cust information","124","105001","street","1-203 high street" ... (0 Replies)
Discussion started by: onesuri
0 Replies

3. Shell Programming and Scripting

Convert rows to columns group

Hi I have the input file following like this "AIX" "AIX 6.0" "AIX 7.0" "Redhat 8" "Redhat 9" "Redhat 5.0 Enterprise Linux" "Sun Solaris 9" "Sun Solaris 10", "Sun Microsystems" "Oracle" .................................Like this 2000 lines I need to convert this input into... (5 Replies)
Discussion started by: selvanraj
5 Replies

4. UNIX for Advanced & Expert Users

Unix Bash: substitute columns in .csv using other .csv columns

Hi All, I have two .csv's input.csv having values as (7 columns) ABC,A19907103,ABC DEV YUNG,2.17,1000,2157,07/07/2006 XYZ,H00213850,MM TRUP HILL,38.38,580,23308,31/08/2010 output.csv having (25 columns) A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y... (4 Replies)
Discussion started by: abhivyas
4 Replies

5. Shell Programming and Scripting

Add the values in second and third columns with group by on first column.

Hi All, I have a pipe seperated file. I need to add the values in second and third columns with group by on first column. MYFILE_28012012_1115|47|173.90 MYFILE_28012012_1115|4|0.00 MYFILE_28012012_1115|6|22.20 MYFILE_28012012_1116|47|173.90 MYFILE_28012012_1116|4|0.00... (3 Replies)
Discussion started by: angshuman
3 Replies

6. Shell Programming and Scripting

Summing columns over group of lines

I have an input file that looks like: ID1 V1 ID2 V2 P1 P2 P3 P4 ..... n no. of columns 1 1 1 1 1.0000 1.0000 1.0000 1.0000 1 1 1 2 0.9999 0.8888 0.7777 0.6666 1 2 1 1 0.8888 0.7777 0.6666 0.5555 1 2 1 2 0.7777 0.6666 0.5555 0.4444 2 1 1 1 0.6666 0.5555 0.4444 0.3333 2 1 1 2 0.5555 0.4444... (4 Replies)
Discussion started by: sdp
4 Replies

7. Shell Programming and Scripting

Get the SUM of TWO columns SEPARATELY by doing GROUP BY on other columns

My File looks like: "|" -> Field separator A|B|C|100|1000 D|E|F|1|2 G|H|I|0|7 D|E|F|1|2 A|B|C|10|10000 G|H|I|0|7 A|B|C|1|100 D|E|F|1|2 I need to do a SUM on Col. 5 and Col.6 by grouping on Col 1,2 & 3 My expected output is: A|B|C|111|11100 (2 Replies)
Discussion started by: machomaddy
2 Replies

8. Shell Programming and Scripting

Average across multiple columns group by

Hi experts, I want to group by average, for multiple columns starting column $7 until NF, group by ($1-$5), please help For just 7th column, I can do awk ' NR>1{ arr += $7 count += 1 } END{ for (a in arr) { print a, arr/count ... (10 Replies)
Discussion started by: ritakadm
10 Replies

9. UNIX for Beginners Questions & Answers

Group by columns and add sum in new columns

Dear Experts, I have input file which is comma separated, has 4 columns like below, BRAND,COUNTRY,MODEL,COUNT NIKE,USA,DUMMY,5 NIKE,USA,ORIGINAL,10 PUMA,FRANCE,DUMMY,20 PUMA,FRANCE,ORIGINAL,15 ADIDAS,ITALY,DUMMY,50 ADIDAS,ITALY,ORIGINAL,50 SPIKE,CHINA,DUMMY,1O And expected output add... (2 Replies)
Discussion started by: ricky1991
2 Replies

10. Shell Programming and Scripting

To group the text (rows) by similar columns-names in a file

As part of some report generation, I've written a script to fetch the values from DB. But, unluckily, for certain Time ranges(1-9.99,10-19.99 etc), I don't have data in DB. In such cases, I would like to write zero (0) instead of empty. The desired output will be exported to csv file. ... (1 Reply)
Discussion started by: kumar_karpuram
1 Replies

LEARN ABOUT DEBIAN

vgdisplay

VGDISPLAY(8)						      System Manager's Manual						      VGDISPLAY(8)

NAME

       vgdisplay - display attributes of volume groups

SYNOPSIS

       vgdisplay  [-A|--activevolumegroups]  [-c|--colon|-s|--short|-v|--verbose]  [-d|--debug]  [-h|--help] [--ignorelockingfailure] [--nosuffix]
       [-P|--partial] [--unitshHbBsSkKmMgGtTpPeE] [--version] [VolumeGroupName[VolumeGroupName...]]

       vgdisplay      --columns      |	    -C	    [--aligned][-d|--debug][-h|-?|--help]	[--ignorelockingfailure][--noheadings][--nosuffix]
       [-o|--options[+]Field[,Field]]  [-O|--sort[+|-]Key1[,[+|-]Key2[,...]]]	[-P|--partial] [--separatorSeparator] [--unbuffered] [--unitshHbB-
       sSkKmMgGtTpPeE] [-v|--verbose] [--version] [VolumeGroupName[VolumeGroupName...]]

DESCRIPTION

       vgdisplay allows you to see the attributes of VolumeGroupName (or all volume groups if none is given) with it's physical and  logical  vol-
       umes and their sizes etc.

       vgs (8) is an alternative that provides the same information in the style of ps (1).

OPTIONS

       See lvm for common options and vgs for options given with --columns.

       -A, --activevolumegroups
	      Only select the active volume groups.

       -c, --colon
	      Generate colon separated output for easier parsing in scripts or programs.  N.B. vgs (8) provides considerably more control over the
	      output.

	      The values are:

	      1  volume group name
	      2  volume group access
	      3  volume group status
	      4  internal volume group number
	      5  maximum number of logical volumes
	      6  current number of logical volumes
	      7  open count of all logical volumes in this volume group
	      8  maximum logical volume size
	      9  maximum number of physical volumes
	      10 current number of physical volumes
	      11 actual number of physical volumes
	      12 size of volume group in kilobytes
	      13 physical extent size
	      14 total number of physical extents for this volume group
	      15 allocated number of physical extents for this volume group
	      16 free number of physical extents for this volume group
	      17 uuid of volume group

       -s, --short
	      Give a short listing showing the existence of volume groups.

       -v, --verbose
	      Display verbose information containing long listings of physical and logical volumes.  If given twice, also display verbose  runtime
	      information of vgdisplay's activities.

       --version
	      Display version and exit successfully.

       --columns|-C
	      Display output in columns, the equivalent of vgs.  Options listed are the same as options given in vgs (8).

SEE ALSO

       lvm(8), vgs(8), pvcreate(8), vgcreate(8), lvcreate(8)

Sistina Software UK					 LVM TOOLS 2.02.95(2) (2012-03-06)					      VGDISPLAY(8)
All times are GMT -4. The time now is 02:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy