Sorry about my delay in gettng back think timezone differences are involved here. looks like we have some nice solutions coming together in this thread now.
This is the pseudo code I had in mind when I first read your requirements:
And the awk coded solution:
This is very similar to RudiC's proposal. The main difference being in the close statement. awk has a limited number of output buffers and using close will become necessary when dealing with a larger input files which can generate too many output files.
And in the spirit of this site this reduced solution could be derived from above:
Last edited by Chubler_XL; 03-02-2020 at 04:09 PM..
This User Gave Thanks to Chubler_XL For This Post:
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)
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)
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)
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)
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)
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)
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)
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)
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)
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 SUSE
gtk2::liststore
Gtk2::ListStore(3) User Contributed Perl Documentation Gtk2::ListStore(3)NAME
Gtk2::ListStore
HIERARCHY
Glib::Object
+----Gtk2::ListStore
INTERFACES
Gtk2::TreeModel
Gtk2::TreeDragSource
Gtk2::TreeDragDest
Gtk2::TreeSortable
Gtk2::Buildable
METHODS
liststore = Gtk2::ListStore->new (...)
o ... (list) of strings
treeiter = $list_store->append
$list_store->clear
$list_store->set_column_types (...)
o ... (list) of strings
$list_store->set ($iter, $col1, $val1, ...)
o $iter (Gtk2::TreeIter)
o $col1 (integer) the first column number
o $val1 (scalar) the first value
o ... (list) pairs of column numbers and values
treeiter = $list_store->insert ($position)
o $position (integer)
treeiter = $list_store->insert_after ($sibling)
o $sibling (Gtk2::TreeIter or undef)
treeiter = $list_store->insert_before ($sibling)
o $sibling (Gtk2::TreeIter or undef)
treeiter = $list_store->insert_with_values ($position, ...)
o $position (integer) position to insert the new row
o ... (list) pairs of column numbers and values
Like doing insert followed by set, except that insert_with_values emits only the row-inserted signal, rather than row-inserted, row-
changed, and, if the store is sorted, rows-reordered as in the multiple-operation case. Since emitting the rows-reordered signal
repeatedly can affect the performance of the program, insert_with_values should generally be preferred when inserting rows in a sorted list
store.
Since: gtk+ 2.6
boolean = $list_store->iter_is_valid ($iter)
o $iter (Gtk2::TreeIter)
Since: gtk+ 2.2
$store->move_after ($iter, $position)
o $iter (Gtk2::TreeIter)
o $position (Gtk2::TreeIter or undef)
Since: gtk+ 2.2
$store->move_before ($iter, $position)
o $iter (Gtk2::TreeIter)
o $position (Gtk2::TreeIter or undef)
Since: gtk+ 2.2
treeiter = $list_store->prepend
boolean = $list_store->remove ($iter)
o $iter (Gtk2::TreeIter)
$store->reorder (...)
o ... (list) of integers the reordered posistions
Reorders store to follow the order indicated by new_order. Note that this function only works with unsorted stores.
A list of position should be passed, one for each item in the list.
Since: gtk+ 2.2
$store->swap ($a, $b)
o $a (Gtk2::TreeIter)
o $b (Gtk2::TreeIter)
Since: gtk+ 2.2
$list_store->set_value ($iter, $col, $val)
o $iter (Gtk2::TreeIter)
o $val (scalar)
o $col (integer)
SEE ALSO
Gtk2, Glib::Object
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::ListStore(3)