Sponsored Content
Full Discussion: Read in Table as a matrix
Top Forums Shell Programming and Scripting Read in Table as a matrix Post 302663409 by radoulov on Thursday 28th of June 2012 05:32:14 AM
Old 06-28-2012
Assuming the last column (values with a leading #) is not present in the real input:

Code:
awk 'NR == 1 {
  n = split($0, y)
  next
  }
{
  for (i = 2; ++i <= NF;)
    print y[i], $i
  print "e"
  }' infile

Otherwise:
Code:
awk 'NR == 1 {
  n = split($0, y)
  next
  }
{
  for (i = 2; ++i < NF;)
    print y[i], $i
  print "e"
  }' infile

 

8 More Discussions You Might Find Interesting

1. Solaris

Need some lib in c/c++ to read db table at one go

Hi All, I need some sort of library or module which read the db table at one go and keep in process memory.My problem is that I have a call processing module which handles the network call and goes for db lookup for subscriber profile in oracle db for every call.I am using Oracle Standard Edition... (0 Replies)
Discussion started by: unisuraj
0 Replies

2. Shell Programming and Scripting

Is it possible to draw table/matrix using shell script?

Hi all, I need to create a matrix of variable rows and columns. Right now i have 3 rows and two columns and following values. Output something like TypeA TypeB TestCase1 Pass Fail TestCase2 Pass ... (2 Replies)
Discussion started by: jakSun8
2 Replies

3. UNIX for Dummies Questions & Answers

Teradate table read?

i have to read some data from a teradata table and use them in my shell script.. how do i do that.. we can use BTEQ .. but i don know how to pass the field values as variables to the shell.. please help me.... (8 Replies)
Discussion started by: depakjan
8 Replies

4. HP-UX

how to read routing table

Hi all, Could someone please explain to me how I should read this routing table, # netstat -rn Routing tables Destination Gateway Flags Refs Interface Pmtu 127.0.0.1 127.0.0.1 UH 0 lo0 32808 10.222.47.82 10.222.47.82 UH... (3 Replies)
Discussion started by: rachael
3 Replies

5. Shell Programming and Scripting

Table to Matrix

Hi, I have a table in the format: 1 0 -1 1 0 2 0 1 -1 0 0 0 3 0 1 1 0 0 0 0 0 0 etc. I am trying to input this to a program, however it is complaining about the fact that it is not in matrix format. How do I add 0's to end of the rows to make them even? Thanks in advance! (2 Replies)
Discussion started by: Rhavin
2 Replies

6. Shell Programming and Scripting

How to sort matrix table in UNIX?

Hello All, i have a file sort.txt with below entries. 1 12 10 16 6 4 20 8 15 i need to sort these entries and the out put should come in a single line. 1 4 6 8 10 12 15 16 20 Can you please help me sort this out? (2 Replies)
Discussion started by: sureshk_85
2 Replies

7. Shell Programming and Scripting

awk to convert table-by-row to matrix table

Hello, I need some help to reformat this table-by-row to matrix? infile: site1 A:o,p,q,r,s,t site1 C:y,u site1 T:v,w site1 -:x,z site2 A:p,r,t,v,w,z site2 C:u,y site2 G:q,s site2 -:o,x site3 A:o,q,s,t,u,z site3 C:y site3 T:v,w,x site3 -:p,routfile: SITE o p q r s t v u w x y... (7 Replies)
Discussion started by: yifangt
7 Replies

8. UNIX for Beginners Questions & Answers

Read Table in file and split

HELLO I need your help please , i need to read a file that contain a table like : Name | Status ------------------ DB 1 | UP DB 2 | UP DB 3 | DOWN DB 4 | UP DB 5 | UP the objective to read each line and check if DB is UP or Down and give me the name of Down database.... (10 Replies)
Discussion started by: Abdellah
10 Replies
HTML::TableParser::Table(3pm)				User Contributed Perl Documentation			     HTML::TableParser::Table(3pm)

NAME
HTML::TableParser::Table - support class for HTML::TableParser DESCRIPTION
This class is used to keep track of information related to a table and to create the information passed back to the user callbacks. It is in charge of marshalling the massaged header and row data to the user callbacks. An instance is created when the controlling TableParser class finds a "<table" tag. The object is given an id based upon which table it is to work on. Its methods are invoked from the TableParser callbacks when they run across an appropriate tag ("tr", "th", "td"). The object is destroyed when the matching "/table" tag is found. Since tables may be nested, multiple HTML::TableParser::Table objects may exist simultaneously. HTML::TableParser uses two pieces of information held by this class -- ids and process. The first is an array of table ids, one element per level of table nesting. The second is a flag indicating whether this table is being processed (i.e. it matches a requested table) or being ignored. Since HTML::TableParser uses the ids information from an existing table to initialize a new table, it first creates an empty sentinel (place holder) table (by calling the HTML::TableParser::Table constructor with no arguments). The class handles missing "/tr", "/td", and "/th" tags. As such (especially when handling multi-row headers) user callbacks may be slightly delayed (and data cached). It also handles rows with overlapping columns LICENSE
This software is released under the GNU General Public License. You may find a copy at http://www.fsf.org/copyleft/gpl.html AUTHOR
Diab Jerius (djerius@cpan.org) SEE ALSO
HTML::Parser, HTML::TableExtract. perl v5.10.0 2007-09-21 HTML::TableParser::Table(3pm)
All times are GMT -4. The time now is 05:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy