Converting Single Column into Multiple rows, but with strings to specific tab column Post: 302838437

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Converting Single Column into Multiple rows, but with strings to specific tab column Post 302838437 by rdrtx1 on Monday 29th of July 2013 04:42:45 PM

Old

07-29-2013

Read Only

try also:

Code:

awk '
BEGIN {
   cols="RANGE,OBB,BO,VER,MVER,PER,CBAA,CBAZA,ALP";
   cc=split(cols, oc, ",");
   for (j=1; j<=cc; j++) printf oc[j] (j<cc ? "\t":"\n");
}
{if ($1 ~ /^[0-9]+$/) {
   if (d[oc[1]]) for (j=1; j<=cc; j++) { printf d[oc[j]] (j<cc ? "\t":"\n"); delete d[oc[j]] ; }
   d[oc[1]]=$1;
 } else {
   ln=$0; sub("[-].*", "", ln); d[ln]=$0;
 }
}
END { for (j=1; j<=cc; j++) printf d[oc[j]] (j<cc ? "\t":"\n"); }
' infile

Last edited by rdrtx1; 07-30-2013 at 05:41 PM.. Reason: corrected clearing stored values.

This User Gave Thanks to rdrtx1 For This Post:

rdrtx1

View Public Profile for rdrtx1

Find all posts by rdrtx1

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting Single Column into Multiple rows

i have single column which is starting with same string(many number of rows) i have to convert each into a single row.how can i do that? laknar std mes 23 55 laknar isd phone no address amount 99 I have to convert above like below. laknar|std|mes|23|55 laknar|isd|phone...

2. Shell Programming and Scripting

Single column into multiple rows

Hi all, I need to convert this file having just one column into two column file current file: a 15 b 21 c 34 d 48 e 10 wanted: a 15 b 21 c 34

3. Shell Programming and Scripting

Converting rows to column

i have output of script as below name,roll_no,01-05-12,02-05-12,03-05-12 sam,12,24,24,24 jon,145,24,24,22 van,29,24,22,24 i want to convert these into columns as output is not fixed please tell me how to convert 1st row in to 1st columns likewise,as many rows are there are to be converted...

4. UNIX for Dummies Questions & Answers

Converting column to rows for every 3 lines in the column

Hi gurus! Please help me with this one. I have an file with the following contents: a b c d e f g h i j I would like to make to transform it to look like this as my output file: a,b,c d,e,f

5. Shell Programming and Scripting

How to merge multiple rows into single row if first column matches ?

Hi, Can anyone suggest quick way to get desired output? Sample input file content: A 12 9 A -0.3 2.3 B 1.0 -4 C 34 1000 C -111 900 C 99 0.09 Output required: A 12 9 -0.3 2.3 B 1.0 -4 C 34 1000 -111 900 99 0.09 Thanks

6. UNIX for Dummies Questions & Answers

[SOLVED] splitting a single column(with spaces) into multiple rows

Hi All, My requisite is to split a single column of phonemes seperated by spaces into multiple rows. my input file is: a dh u th a qn ch A v U r k my o/p should be like: adhu a dh u

7. Shell Programming and Scripting

Transpose multiple rows (with a mix of space and enter) to a single column

How to change the uploaded weekly file data to the following format? New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi. BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430 BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430...

8. Shell Programming and Scripting

Convert single column into multiple rows

Convert Single column to multiple rows file a.txt contains data like below Server=abc Run=1 Tables=10 Sessions=16 Time=380 Jobs=5 Server=abc Run=2 Tables=15 Sessions=16 Time=400 Jobs=5 Server=abc Run=3 Tables=20 Sessions=16 Time=450

9. Shell Programming and Scripting

Converting a single row to multiple rows

Hi, I want to convert a single row values to multiple rows, but the no. of rows are not fixed. For example, I have a row as below abc-def-lmn-mno-xyz out put should be get abc get def get lmn get xyz

10. Shell Programming and Scripting

Converting Single Column into Multiple rows

Hi .. anyone can you help me ? i need to convert text below into multiple columns interface; GigabitEthernet0/0/0/0 description; TRUNK_PE-D2-JT2-VPN_Gi0/0/0/0_TO_ME4-A-JKT-JT_4/1/1_1G mtu 9212 negotiation auto interface; GigabitEthernet0/0/0/0.11 description; tes encapsulation;...

LEARN ABOUT NETBSD

infocmp

INFOCMP(1)						    BSD General Commands Manual 						INFOCMP(1)

NAME

     infocmp -- compare or print compiled terminfo descriptions

SYNOPSIS

     infocmp [-1acnqux] [-A database] [-B database] [-w cols] [term ...]

DESCRIPTION

     The infocmp reconstructs the first available terminfo(5) definition found for term and prints the result in a terminfo(5) format.	Capability
     types are grouped together and new types start new lines, first flags, then numbers, then strings.  Capabilities are sorted by their name.
     If a second term is given then the capabilities are compared against each other.

     The following options are available:

     -1 	      Print one capability per line.

     -A database      Use this database to load the first terminal definition.

     -B database      Use this database to load subsequent terminal definitions.

     -a 	      Include commented out capabilities.  This only works if the database was compiled with the -a flag passed to tic(1).  This
		      also sets the -x flag as infocmp retains commented out capabilities as non standard.

     -c 	      Print capabilities common to each definition.

     -n 	      Print capabilities that do not exist in either definition.

     -q 	      Make the comparison listing shorter by omitting subheadings and using - for absent capabilities, @ for canceled capabilities
		      rather than NULL.

     -u 	      Build a new terminal description for the first terminal description, using subsequent terminal descriptions.  This also sets
		      the -a flag.

     -w cols	      Limit the width to cols.

     -x 	      Include non-standard capabilities.  More -x only handles non-standard capabilities.  This only works if the database was
		      compiled with the -x flag passed to tic(1).

ENVIRONMENT

     COLUMNS	      Override columns returned by the output terminal.  -w cols supersedes this.

     TERM	      infocmp uses the contents of the TERM environment variable if no terminal name is given on the command line.

EXIT STATUS

     The infocmp utility exits 0 on success, and >0 if an error occurs.

SEE ALSO

     tic(1), terminfo(5)

STANDARDS

     The infocmp utility outputs information that conforms to the X/Open Curses Issue 4, Version 2 (``XCURSES4.2'') standard.

AUTHORS

     Roy Marples <roy@NetBSD.org>

BSD
								 February 5, 2010							       BSD