Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Split a file based on number sum at the second column and the third column.
Top Forums UNIX for Beginners Questions & Answers Split a file based on number sum at the second column and the third column. Post 303044704 by nezabudka on Monday 2nd of March 2020 04:07:16 AM
Old 03-02-2020
maybe so?
Code:
#!/bin/bash

step=2999
declare -i start=12109 end=start+step count=1
stop=$(awk '{if($3>max) max=$3} END {print max}' file)

while [ $end -le $stop ]; do
        awk -vA=$start -vZ=$end -vf="file$count" '
                $2>=A && $3<=Z {print > f}
        ' file
        start+=step
        end+=step
        count+=1
done

This User Gave Thanks to nezabudka For This Post:
demo10
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I sum one column based on another column?

Hi, I am new to this forum and new to awk. I have a file that contains 2 columns. Heres an example of what it looks like: 10 + 20 + 40 + 50 - 70 - So the file is tab-delimited. What I want to do is add 10 to column 1 whenever column 2 is + and substract 10 from column 1... (1 Reply)
Discussion started by: phil_heath
1 Replies

2. Shell Programming and Scripting

Split single file into multiple files based on the number in the column

Dear All, I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...): ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Discussion started by: tomasl
3 Replies

3. Shell Programming and Scripting

Split the file based on column

Hi, I have a file sample_1.txt (300k rows) which has data like below: * Also each record is around 64k bytes 11|1|abc|102553|125589|64k bytes of data 10|2|def|123452|123356|...... 13|2|geh|144351|121123|... 25|4|fgh|165250|118890|.. 14|1|abc|186149|116657|......... (6 Replies)
Discussion started by: sol_nov
6 Replies

4. Shell Programming and Scripting

Sum Of Column Based On Column Condition

I have a following inputfile MT,AP,CDM,TTML,MUM,GS,SUCC,3 MT,AP,CDM,TTSL,AP,GS,FAIL,9 MT,AP,CDM,RCom,MAH,GS,SUCC,3 MT,AP,CDM,RTL,HP,GS,SUCC,1 MT,AP,CDM,Uni,UPE,GS,SUCC,2 MT,AP,CDM,Uni,MUM,GS,SUCC,2 TTSL,AP,GS,MT,MAH,CDM,SUCC,20 TTML,AP,GS,MT,MAH,CDM,FAIL,10... (2 Replies)
Discussion started by: siramitsharma
2 Replies

5. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies

6. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

Hi, I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column) The input is for example, after sorted: K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies

7. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h (1 Reply)
Discussion started by: Priti2277
1 Replies

8. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ... (11 Replies)
Discussion started by: Priti2277
11 Replies

9. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies

10. UNIX for Beginners Questions & Answers

Sum in file based column

Hi All, I have a file as below and want to sum based on the id in the first column Input 10264;ATE; 12 10265;SES;11 10266AUT;50 10264;ATE;10 10265;SES;13 10266AUT;89 10264;ATE;1 10265;SES;15 10266AUT;78 Output 10264;ATE; 23 10265;SES;39 10266AUT;139 (6 Replies)
Discussion started by: arunkumar_mca
6 Replies

LEARN ABOUT DEBIAN

gtk2::listitem

Gtk2::ListItem(3pm)					User Contributed Perl Documentation				       Gtk2::ListItem(3pm)

NAME

       Gtk2::ListItem - wrapper for GtkListItem

DESCRIPTION

       Gtk2::ListItem is the widget used for each item in a Gtk2::List.  Gtk2::List and Gtk2::ListItem are deprecated; use Gtk2::TreeView and a
       Gtk2::ListStore instead.

       Gtk2::ListItem is included in Gtk2-Perl only because Gtk2::Combo contains a Gtk2::List, and Gtk2::Combo's replacement, Gtk2::ComboBox,
       didn't appear in gtk+ until 2.4.0.

HIERARCHY

	 Glib::Object
	 +----Glib::InitiallyUnowned
	      +----Gtk2::Object
		   +----Gtk2::Widget
			+----Gtk2::Container
			     +----Gtk2::Bin
				  +----Gtk2::Item
				       +----Gtk2::ListItem

INTERFACES

	 Glib::Object::_Unregistered::AtkImplementorIface
	 Gtk2::Buildable

METHODS

   widget = Gtk2::ListItem->new ($label=undef)
       o   $label (string)

   widget = Gtk2::ListItem->new_with_label ($label=undef)
       o   $label (string)

   $list_item->deselect
   $list_item->select
SIGNALS

       select-all (Gtk2::ListItem)
       unselect-all (Gtk2::ListItem)
       toggle-focus-row (Gtk2::ListItem)
       undo-selection (Gtk2::ListItem)
       start-selection (Gtk2::ListItem)
       end-selection (Gtk2::ListItem)
       toggle-add-mode (Gtk2::ListItem)
       extend-selection (Gtk2::ListItem, Gtk2::ScrollType, float, boolean)
       scroll-vertical (Gtk2::ListItem, Gtk2::ScrollType, float)
       scroll-horizontal (Gtk2::ListItem, Gtk2::ScrollType, float)

ENUMS AND FLAGS

   enum Gtk2::ScrollType
       o   'none' / 'GTK_SCROLL_NONE'

       o   'jump' / 'GTK_SCROLL_JUMP'

       o   'step-backward' / 'GTK_SCROLL_STEP_BACKWARD'

       o   'step-forward' / 'GTK_SCROLL_STEP_FORWARD'

       o   'page-backward' / 'GTK_SCROLL_PAGE_BACKWARD'

       o   'page-forward' / 'GTK_SCROLL_PAGE_FORWARD'

       o   'step-up' / 'GTK_SCROLL_STEP_UP'

       o   'step-down' / 'GTK_SCROLL_STEP_DOWN'

       o   'page-up' / 'GTK_SCROLL_PAGE_UP'

       o   'page-down' / 'GTK_SCROLL_PAGE_DOWN'

       o   'step-left' / 'GTK_SCROLL_STEP_LEFT'

       o   'step-right' / 'GTK_SCROLL_STEP_RIGHT'

       o   'page-left' / 'GTK_SCROLL_PAGE_LEFT'

       o   'page-right' / 'GTK_SCROLL_PAGE_RIGHT'

       o   'start' / 'GTK_SCROLL_START'

       o   'end' / 'GTK_SCROLL_END'

SEE ALSO

       Gtk2, Glib::Object, Glib::InitiallyUnowned, Gtk2::Object, Gtk2::Widget, Gtk2::Container, Gtk2::Bin, Gtk2::Item

COPYRIGHT

       Copyright (C) 2003-2011 by the gtk2-perl team.

       This software is licensed under the LGPL.  See Gtk2 for a full notice.

perl v5.14.2							    2012-05-27						       Gtk2::ListItem(3pm)
All times are GMT -4. The time now is 05:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy