Sponsored Content
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:
 

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
Gtk2::SpinButton(3)					User Contributed Perl Documentation				       Gtk2::SpinButton(3)

NAME
Gtk2::SpinButton HIERARCHY
Glib::Object +----Glib::InitiallyUnowned +----Gtk2::Object +----Gtk2::Widget +----Gtk2::Entry +----Gtk2::SpinButton INTERFACES
Glib::Object::_Unregistered::AtkImplementorIface Gtk2::Buildable Gtk2::Editable Gtk2::CellEditable METHODS
widget = Gtk2::SpinButton->new ($adjustment, $climb_rate, $digits) o $adjustment (Gtk2::Adjustment) o $climb_rate (double) o $digits (integer) widget = Gtk2::SpinButton->new_with_range ($min, $max, $step) o $min (double) o $max (double) o $step (double) adjustment = $spin_button->get_adjustment $spin_button->set_adjustment ($adjustment) o $adjustment (Gtk2::Adjustment) $spin_button->configure ($adjustment, $climb_rate, $digits) o $adjustment (Gtk2::Adjustment) o $climb_rate (double) o $digits (integer) integer = $spin_button->get_digits $spin_button->set_digits ($digits) o $digits (integer) (step, page) = $spin_button->get_increments $spin_button->set_increments ($step, $page) o $step (double) o $page (double) boolean = $spin_button->get_numeric $spin_button->set_numeric ($numeric) o $numeric (boolean) (min, max) = $spin_button->get_range $spin_button->set_range ($min, $max) o $min (double) o $max (double) boolean = $spin_button->get_snap_to_ticks $spin_button->set_snap_to_ticks ($snap_to_ticks) o $snap_to_ticks (boolean) $spin_button->spin ($direction, $increment) o $direction (Gtk2::SpinType) o $increment (double) $spin_button->update spinbuttonupdatepolicy = $spin_button->get_update_policy $spin_button->set_update_policy ($policy) o $policy (Gtk2::SpinButtonUpdatePolicy) integer = $spin_button->get_value_as_int double = $spin_button->get_value $spin_button->set_value ($value) o $value (double) boolean = $spin_button->get_wrap $spin_button->set_wrap ($wrap) o $wrap (boolean) PROPERTIES
'adjustment' (Gtk2::Adjustment : readable / writable / private) The adjustment that holds the value of the spinbutton 'climb-rate' (double : readable / writable / private) The acceleration rate when you hold down a button 'digits' (Glib::UInt : readable / writable / private) The number of decimal places to display 'numeric' (boolean : readable / writable / private) Whether non-numeric characters should be ignored 'snap-to-ticks' (boolean : readable / writable / private) Whether erroneous values are automatically changed to a spin button's nearest step increment 'update-policy' (Gtk2::SpinButtonUpdatePolicy : readable / writable / private) Whether the spin button should update always, or only when the value is legal 'value' (double : readable / writable / private) Reads the current value, or sets a new value 'wrap' (boolean : readable / writable / private) Whether a spin button should wrap upon reaching its limits SIGNALS
value-changed (Gtk2::SpinButton) change-value (Gtk2::SpinButton, Gtk2::ScrollType) integer = input (Gtk2::SpinButton, gpointer) boolean = output (Gtk2::SpinButton) wrapped (Gtk2::SpinButton) 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' enum Gtk2::SpinButtonUpdatePolicy o 'always' / 'GTK_UPDATE_ALWAYS' o 'if-valid' / 'GTK_UPDATE_IF_VALID' enum Gtk2::SpinType o 'step-forward' / 'GTK_SPIN_STEP_FORWARD' o 'step-backward' / 'GTK_SPIN_STEP_BACKWARD' o 'page-forward' / 'GTK_SPIN_PAGE_FORWARD' o 'page-backward' / 'GTK_SPIN_PAGE_BACKWARD' o 'home' / 'GTK_SPIN_HOME' o 'end' / 'GTK_SPIN_END' o 'user-defined' / 'GTK_SPIN_USER_DEFINED' SEE ALSO
Gtk2, Glib::Object, Glib::InitiallyUnowned, Gtk2::Object, Gtk2::Widget, Gtk2::Entry COPYRIGHT
Copyright (C) 2003-2008 by the gtk2-perl team. This software is licensed under the LGPL. See Gtk2 for a full notice. perl v5.12.1 2010-07-05 Gtk2::SpinButton(3)
All times are GMT -4. The time now is 01:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy