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
Code:
aa bb cc 2 NA100 dd
aa b1 c2 2 NA102 de
File after modification
Code:
aa bb cc NA100 dd
aa b1 c2 NA102 de
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
layout::manager::grid
Layout::Manager::Grid(3pm) User Contributed Perl Documentation Layout::Manager::Grid(3pm)NAME
Layout::Manager::Grid - Simple grid-based layout manager.
DESCRIPTION
Layout::Manager::Grid is a layout manager places components into evenly divided cells.
When you instantiate a Grid manager, you must supply it with a count of how many rows and columns it will have. For example, a Grid with 1
column and 2 rows would look like:
+--------------------------------+
| |
| component 1 |
| |
+--------------------------------+
| |
| component 2 |
| |
+--------------------------------+
The container is divided into as many <rows> * <columns> cells, with each taking up an equal amount of space. A grid with 3 columns and 2
rows would create 6 cells that consume 33% of the width and 50% of the height.
Components are placed by specifying the cell they reside in via the row and column number.
$container->add_component($comp, { row => 0, column => 3 });
$container->add_component($comp, { row => 0, column => 2, height => 2 });
Optionally, you may choose to override the default "width" or "height" of 1. Setting it to a something else will cause the component to
consume that many rows or columns worth of space.
Grid is similar to Java's GridLayout <http://java.sun.com/docs/books/tutorial/uiswing/layout/grid.html>.
SYNOPSIS
$cont->add_component($comp1, { row => 0, column => 1 });
$cont->add_component($comp2, { row => 0, column => 2 });
my $lm = Layout::Manager::Grid->new(rows => 1, columns => 2);
$lm->do_layout($con);
DYNAMIC SIZING
If the container that the Grid is manging does not have one or both of it's dimensions set, Grid will compute the appropriate sizes. The
simple way for me to avoid writing a long explanation is to say it works similar to HTML tables. Rows will become as big as their biggest
consituent, as will columns. It is common to add a Grid-managed component to a scene with only one of it's dimensions set.
ATTRIBUTES
columns
The number of columns in this Grid.
rows
The number of rows in this Grid.
METHODS
do_layout
Size and position the components in this layout.
AUTHOR
Cory Watson, "<gphat@cpan.org>"
COPYRIGHT & LICENSE
Copyright 2008 - 2010 Cory G Watson
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.12.3 2011-05-16 Layout::Manager::Grid(3pm)