Deleting cells that contain a specific number only from a space delimited text file
I have this space delimited large text file with more than 1,000,000+ columns and about 100 rows. I want to delete all the cells that consist of just 2 (leave 2's that are not by themselves intact):
File before modification
File after modification
How would I delete all the cells that just have 2? Thanks!
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by vgersh99; 05-31-2011 at 07:25 PM..
Reason: please start using code tags!
Hi
I am trying to search a firewall syslog space delimeted file for all of the different tcp and udp destination ports.
I know that grep will find lines that contain specific text. And I have tried using the the the cut command to cut out of the file certain colums. However the test I am... (6 Replies)
I have a space delimited text file with 1,000,000+ columns and 100 rows. I want to delete columns 2 through 5 (2 and 5) included from the text file. How do I do that? Thanks. (3 Replies)
How do you delete cells from a space delimited text file given row and column number? Letś say the row number is r and the column number is c. Thanks! (5 Replies)
I have a space delimited text file with 1,000,000+ columns? I would only like to view specific ones (let's say through 1:10), how can I do that? Thanks! (3 Replies)
I have a text file with irregular spacing between values which makes it really difficult to manipulate. Is there an easy way to convert it into a space delimited text file so that all the spaces, double spaces, triple spaces, tabs between numbers are converted into spaces. The file looks like this:... (5 Replies)
I have a space delimited text file with two columns. I would like to add NA to the first column of the text file.
Input:
19625 10.4791768259
19700 10.8146489183
19701 10.9084026759
19702 10.9861346978
19703 10.9304364984
Output:
NA19625 10.4791768259
NA19700 10.8146489183... (1 Reply)
I have a space delimited text file where I want to replace all cells that are 0 with NA. However I cannot simply use 'sed/0/NA/g' because there are other 0's in the text file that are part of numbers.
Example input:
896.933464285715
0
874.691732142857
866.404660714286
Output:... (1 Reply)
Hi,
I have a space delimited text file but I only want to change the first space to a tab and keep the rest of the spaces intact. How do I go about doing that? Thanks! (3 Replies)
Discussion started by: evelibertine
3 Replies
LEARN ABOUT DEBIAN
goo::canvas::tablemodel
Goo::Canvas::TableModel(3pm) User Contributed Perl Documentation Goo::Canvas::TableModel(3pm)NAME
Goo::Canvas::TableModel - wrapper for GooCanvasTableModel
HIERARCHY
Glib::Object
+----Goo::Canvas::ItemModelSimple
+----Goo::Canvas::GroupModel
+----Goo::Canvas::TableModel
INTERFACES
Goo::Canvas::ItemModel
METHODS
itemmodel = Goo::Canvas::TableModel->new ($parent, ...)
o $parent (Goo::Canvas::ItemModel)
o ... (list)
PROPERTIES
'column-spacing' (double : default 0 : readable / writable)
The default space between columns
'homogeneous-columns' (boolean : default false : readable / writable)
If all columns are the same width
'homogeneous-rows' (boolean : default false : readable / writable)
If all rows are the same height
'horz-grid-line-width' (double : default 0 : readable / writable)
The width of the grid line to draw between rows
'row-spacing' (double : default 0 : readable / writable)
The default space between rows
'vert-grid-line-width' (double : default 0 : readable / writable)
The width of the grid line to draw between columns
'x-border-spacing' (double : default 0 : readable / writable)
The amount of spacing between the lefmost and rightmost cells and the border grid line
'y-border-spacing' (double : default 0 : readable / writable)
The amount of spacing between the topmost and bottommost cells and the border grid line
SEE ALSO
Glib::Object, Goo::Canvas::ItemModelSimple, Goo::Canvas::GroupModel
COPYRIGHT
Copyright (C) 2011 Gtk2-Perl Team
perl v5.14.2 2011-11-16 Goo::Canvas::TableModel(3pm)