Row blocks to column blocks Post: 302807307

Sponsored Content

Top Forums Shell Programming and Scripting Row blocks to column blocks Post 302807307 by yifangt on Tuesday 14th of May 2013 01:01:57 PM

05-14-2013

Registered User

Row blocks to column blocks

Hello,
Searched for a while and found some "line-to-column" script. My case is similar but with multiple fields each row:

Code:

S02     Length    Per
S02     7043      3.864
S02     54477    29.89
S02     104841    57.52
S03     Length    Per
S03     1150    0.835
S03     1321    0.96
S03     6432    4.675
S03     6922    5.031
S03     11705    8.507
S03     13793    10.02
S03     34275    24.91
S03     38238    27.79
S04    Length    Per
S04     11398    8.887
S04     17396    13.56
S04     94014    73.3

And I want the output as:

Code:

S02    Length    Per      S03    Length    Per   S04  Length    Per
S02    7043      3.864    S03    1150    0.835   S04 11398    8.887
S02    54477     29.89    S03    1321    0.96    S04 17396    13.56
S02    104841    57.52    S03    6432    4.675   S04 94014    73.3
                          S03    6922    5.031            
                          S03    11705    8.507            
                          S03    13793    10.02            
                          S03    34275    24.91            
                          S03    38238    27.79

What I tried is to cut each block (by field 1) to separate file and then use "paste" to combine the individual files. I feel there must be an easier way with awk.
Any help will be appreciated.

yifangt

View Public Profile for yifangt

Find all posts by yifangt

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract sequence blocks

Hi, I have an one-line file consisting of a sequence of 660 letters. I would like to extract 9-letter blocks iteratively: ASDFGHJKLQWERTYUIOPZXCVBNM first block: ASDFGHJKL 1nd block: SDFGHJKLQ What I have so far only gives me the first block, can anyone please explain why? cat...

2. Shell Programming and Scripting

How to read text in blocks

Hi, I have file which contains information written in blocks (every block is different). Is it possible to read every block one by one to another file (one block per file). The input is something like this <block1> <empty line> <block2> <empty line> ... ... ... <block25> <empty...

3. Shell Programming and Scripting

Removing blocks from a file

I have a file like the one below. Each record is separated with > In between I have lines consisting of 3 numeric values separated by a space. I need to take each block between the > sign and read the first number in the line. Then take the first after the > sign and the last before the >...

4. Shell Programming and Scripting

Help with Script using Command Blocks

Hello, I am trying to create a shell script that use command block (don�t really know if this is the correct way to say it), but while one version works fine, the other one is not working at all. So let me show an example of this "command block" I�m using and its working ok: cat << _EOF_ `echo...

5. UNIX for Dummies Questions & Answers

Convert 512-blocks to 4k blocks

I'm Unix. I'm looking at "df" on Unix now and below is an example. It's lists the filesystems out in 512-blocks, I need this in 4k blocks. Is there a way to do this in Unix or do I manually convert and how? So for container 1 there is 7,340,032 in size in 512-blocks. What would the 4k block be...

6. Shell Programming and Scripting

how to split this file into blocks and then send these blocks as input to the tool called Yices?

Hello, I have a file like this: FILE.TXT: (define argc :: int) (assert ( > argc 1)) (assert ( = argc 1)) <check> # (define c :: float) (assert ( > c 0)) (assert ( = c 0)) <check> # now, i want to separate each block('#' is the delimeter), make them separate files, and then send them as...

7. UNIX for Dummies Questions & Answers

Duplicate blocks in an inode

I have 2 duplicate blocks in an inode and I want to get rid of one of them so that I can get into my pc. The message I get is Multiply-claimed block(s) in inode 5997500: 12690101 12690101. All help is appreciated. Thanks

8. Shell Programming and Scripting

Transpose info that is within blocks

Hello to all in forum, I have a big file with blocks of data. Each block begins with "BeginOfRecord"....

9. Shell Programming and Scripting

Blocks into table

please help, I have a huge file with blocks of data which I need to convert to a tabular format. Input sample id: GO:0000017 name: alpha-glucoside transport namespace: biological_process def: "The directed movement of alpha-glucosides into, out of or within a cell, or between...

LEARN ABOUT SUNOS

ifdhgetcapabilities

IFDHGetCapabilities(3SMARTCARD) 			    Smartcard Library Functions 			   IFDHGetCapabilities(3SMARTCARD)

NAME

       IFDHGetCapabilities - get IFD capabilities

SYNOPSIS

       #include <smartcard/ifdhandler.h>

       RESPONSECODE IFDHGetCapabilities(DWORD Lun, DWORD Tag, PDWORD Length, PUCHAR Value);

PARAMETERS

       The IFDHGetCapabilities() function takes the following parameters:

   Input
       Lun	       Logical Unit Number

       Tag	       Tag of the desired data value

       Length	       Maximum length of the desired data value

   Output
       Length	       Length of the data returned

       Value	       Value of the desired data

DESCRIPTION

       The IFDHGetCapabilities() function retrieves the terminal or card capabilities for the terminal or card specified by Lun.

       The Tag parameter can have one of the following values:

       TAG_IFD_ATR		       Return the ATR (Answer To Reset). This is the default value.

       TAG_IFD_SIMULTANEOUS_ACCESS     Return  the number of sessions the driver can handle. This value is used for multiple terminals sharing the
				       same IFD handler.

       TAG_IFD_SLOTS_NUMBER	       Return the number of slots in this terminal.

       If the TAG_IFD_SIMULTANEOUS_ACCESS and TAG_IFD_SLOTS_NUMBER tags are not supported, the error value IFD_ERROR_TAG must be returned.

RETURN VALUES

       The following values are returned:

       IFD_SUCCESS		       Successful completion.

       IFD_ERROR_TAG		       An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Evolving			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       IFDHCreateChannelByName(3SMARTCARD), attributes(5)

NOTES

       This manual page is derived from the MUSCLE PC/SC IFD Driver Developer Kit documentation.  License  terms  and  attribution  and  copyright
       information  for this interface are available at the default location /var/sadm/pkg/SUNWocfh/install/copyright.	If  the  Solaris Operating
       Environment has been installed anywhere other than the default location, modify the path to access the file at the installed location.

SunOS 5.10							    4 Dec 2002					   IFDHGetCapabilities(3SMARTCARD)