04-15-2014
Quote:
Originally Posted by
CarloM
It looks like full rows have 2 tabs between fields 1 and 2, but rows with missing data have only 1 tab before what appears to be field 2.
Is that the case, or is it just a formatting artifact and the file is really (single) tab-delimited?
Dear CarloM,
For some rows, column 2 is blank. For some some rows, column 1, 3, 4, 5, 6, 7, 8, 12, 13 are blank.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a sample file as shown below --
id parent name dba
-----------------------------------... (7 Replies)
Discussion started by: sumirmehta
7 Replies
2. UNIX for Dummies Questions & Answers
Hi, I am trying to sort a file first by the string column, then by the number column.
file:
xyz1 2
xyzX 4
xyz2 1
xyz13 3
xyz11 5
xyz13 10
xyz1 1
xyz10 1
xyz4 2
result should be
xyz1 1
xyz1 2 ... (3 Replies)
Discussion started by: fargo
3 Replies
3. UNIX for Dummies Questions & Answers
Hi Everybody,
I am just new to UNIX as well as to this forum. I have a text file with 10,000 coloumns and each coloumn contains values separated by space. I want to separate them into new coloumns..the file is something like this
as ad af 1 A
as ad af 1 D
...
...
1 and A are in one... (7 Replies)
Discussion started by: Unilearn
7 Replies
4. Shell Programming and Scripting
Hi,
I am very new to Unix script. Suppose i have a file with column header:
NAME1 NAME2 Address Tel
And I always need to make a file with column header:
ID NAME1 NAME2 EMail Address Tel
For the columns that do not exist in the file, I would still like to make a column with blank.
... (11 Replies)
Discussion started by: nightrider
11 Replies
5. UNIX for Dummies Questions & Answers
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies
6. Shell Programming and Scripting
File will have two columns key column and second column which is pipe separated and that need to be sorted.
Below is input file.
1, D|B|A|C
2, C|A|B
3, E|A|F|G|H|D|B|C
4, A|B|D|C|F
Output should be
1, A|B|C|D
2, A|B|C
3, A|B|C|D|E|F|G|H
4, A|B|D|C|F (11 Replies)
Discussion started by: girish119d
11 Replies
7. Shell Programming and Scripting
Hi,
i have a csv file which have headers and values of it like below :
headers --> CI Ref SerialNumber LastScanDate
values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000
i want to have a above csv in below format :
headers --> CI Name CI Description CI Ref... (6 Replies)
Discussion started by: omkar.jadhav
6 Replies
8. Shell Programming and Scripting
Hello,
I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs.
I was thinking of using sed to replace instances of double tab with blank,
sed 's/\t\t//g'
All of the examples... (2 Replies)
Discussion started by: LMHmedchem
2 Replies
9. Shell Programming and Scripting
I have a file with the following format:
X|High|2|GIC|DM||XHM|||6 Months
X|Moderate|2|GIC|DM||XHM|||6 Months
X|High|2|GCM|DM||XSF|||6 Months
X|Med|2|GCM|DM||XSF|||6
Here there are ten columns but I need to print rows having blank records in any of the rows (except for 6th,8th and 9th... (10 Replies)
Discussion started by: chatwithsaurav
10 Replies
10. Shell Programming and Scripting
I've spent the past hour trying different things and googling for this solution and cannot find the answer. Found variations of this, but not this exact thing.
I have the following text, which is the output from our mainframe. Each field is on a separate line, with a blank line between each... (7 Replies)
Discussion started by: lupin..the..3rd
7 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)