Transpose a file Post: 302948379

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Transpose a file Post 302948379 by RudiC on Monday 29th of June 2015 10:53:33 AM

06-29-2015

Registered User

Try

Code:

awk     'NR>1   {LN[$4]; HD[$5]; MX[$4,$5]=$2}
         END    {               printf "%10s", ""; for (i in HD) printf "%10s", i; print "";
                 for (j in LN) {printf "%10s",j;   for (i in HD) printf "%10s", MX[j,i]; print ""}
                }
        ' file
                            10       7.1       7.2      11.1         1         2         3         4         5         6         8         9
       C01                             T                                       T         T         T         T         T                    
       D02                                                 T                                                                     C         C
        11        xx                                                                                                                        
       A01                                                           T         T         T                                                  
       A02                                                                                         T         T         T                    
       B01                   T                  NA                                                                               T         T
       B10                                                           T

The line with "11" is there as your input file has a missing entry for it.

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

transpose file

Hi all, I have a file in the below format.... <A> B C <A> E F <A> G H I need the result file to be: <A>BC <A>EF <A>GH

2. Shell Programming and Scripting

Transpose an entire text file

Hello all, I want to transpose the rows of a file to the columns (every characters include spaces), i.e.: input: abcdefg 123 456 output: a1 b2 c3 d e4 f5 g6 I wrote a script: #!/bin/csh -f

3. Shell Programming and Scripting

File Transpose

Hi ALL I have one input file say FILE1 which looks as below. a=1 b=2 c=3 a=4 b=5 c=6 . . . Here a,b,c...etc are variable names. The output file(FILE2) should look like 1,2,3 4,5,6 ..... .....

4. Shell Programming and Scripting

Rows to Columns - File Transpose

Hi I have an input file and I want to transpose it but I need to take care that if any field is missing for a record it should be popoulated with space for that field - using a shell script INFILE ---------- emp=1 sal=2 loc=abc emp=2 sal=21 sal=22 loc=xyz emp=5 loc=abc OUTFILE...

5. Shell Programming and Scripting

Transpose a file

input IndID ID1 ID2 ID3 a1 a/a b/b c/c a2 a/a b/b c/c a3 a/b b/b c/d a6 a/b b/b c/e a8 a/a b/c c/e a9 b/b b/d c/e output IDName IndID IDtype C_No ID1 a1 a/a 1 ID1 a2 a/a 1 ID1 a8 ...

6. Shell Programming and Scripting

Transpose a text file.

Hello, I have a text file which is like a matrix m rows and n columns. Now I want to convert it into n rows and m columns. Thanks for hint.

7. Shell Programming and Scripting

Transpose whole file and specific columns

Hi, I have a file like this a b c d e f g h i j k l Case1: I want to transpose the whole file Output1 a d g j b e h k c f i l Case2 Transpose a specific column - Say 3rd

8. Shell Programming and Scripting

File transpose problem

Hi Friends, I have a file with a structure like this: <file1.csv> field1,field2,field3,field4,field5,field6,field7,field8,field9,field10,field11,field12 Few Salient points on the file's structure (1)The fields from field1 to field6 is fixed and they would always be present in the file...

9. UNIX for Dummies Questions & Answers

Transpose File

Have various files like this: InSlot=0x00000001 InPort=0x00000000 Inref=0x0000002f InSID=0x00000001 OutSlot=0x00000001 OutPort=0x00000002 Outref=0x00000000 OutSID=0x0000000b OutUName_2=14 InSlot=0x00000001 InPort=0x00000000 Inref=0x000001a8 InSID=0x00000001 OutSlot=0x00000001...

10. Shell Programming and Scripting

Transpose a txt file

Hello, I have a text file with 148 rows and 2532691 columns. I need to transpose the data. The command that I am using is awk ' { for (i=1; i<=NF; i++) { a = $i } } NF>p { p = NF } END { for(j=1; j<=p; j++) { str=a for(i=2; i<=NR; i++){ ...

LEARN ABOUT DEBIAN

ocf_heartbeat_sfex

OCF_HEARTBEAT_SFEX(7)						OCF resource agents					     OCF_HEARTBEAT_SFEX(7)

NAME

       ocf_heartbeat_sfex - Manages exclusive access to shared storage using Shared Disk File EXclusiveness (SF-EX)

SYNOPSIS

       sfex [start | stop | monitor | meta-data | validate-all]

DESCRIPTION

       Resource script for SF-EX. It manages a shared storage medium exclusively .

SUPPORTED PARAMETERS

       device
	   Block device path that stores exclusive control data.  (required, string, no default)

       index
	   Location in block device where exclusive control data is stored. 1 or more is specified. Default is 1.  (optional, integer, default 1)

       collision_timeout
	   Waiting time when a collision of lock acquisition is detected. Default is 1 second.	(optional, integer, default 1)

       monitor_interval
	   Monitor interval(sec). Default is 10 seconds (optional, integer, default 10)

       lock_timeout
	   Valid term of lock(sec). Default is 100 seconds. The lock_timeout is calculated by the following formula. .sp lock_timeout =
	   monitor_interval + "The expiration time of the lock" .sp We suggest 90 seconds as a default value of the "The expiration time of the
	   lock", but you should change it in consideration of access delay to the shared disk and the switch time of the multipath driver. .sp
	   The lock timeout have an impact on start action timeout because start action timeout value is calculated by the following formula. .sp
	   start timeout = collision_timeout + lock_timeout + "safety margin" .sp The "safety margin" is decided within the range of about 10-20
	   seconds(It depends on your system requirement).  (optional, integer, default 100)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 120s.

       stop
	   Stops the resource. Suggested minimum timeout: 20s.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 10s. Suggested interval: 10s.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5s.

       validate-all
	   Performs a validation of the resource configuration. Suggested minimum timeout: 5s.

EXAMPLE

       The following is an example configuration for a sfex resource using the crm(8) shell:

	   primitive p_sfex ocf:heartbeat:sfex 
	     params 
	       device=string 
	     op monitor depth="0" timeout="10s" interval="10s"

SEE ALSO

       http://www.linux-ha.org/wiki/sfex_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

resource-agents UNKNOWN 					    03/09/2014						     OCF_HEARTBEAT_SFEX(7)