Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Column to Rows
Top Forums Shell Programming and Scripting Column to Rows Post 302404954 by durden_tyler on Wednesday 17th of March 2010 04:04:10 PM
Old 03-17-2010
And here's a Perl solution -

Code:
$
$ cat f9
switch A
port 2/6
port 2/7
port 3/8

switch B
port 1/2
port 1/5

switch C
port 3/1
port 3/2
port 3/3
port 3/4
$
$ perl -lne 'chomp; push @x,$_; if(/^$/ or eof){$y=join("|",@x); $y=~s/\|$//; print $y; @x=()}' f9
switch A|port 2/6|port 2/7|port 3/8
switch B|port 1/2|port 1/5
switch C|port 3/1|port 3/2|port 3/3|port 3/4
$
$ # or maybe this...
$
$ perl -lne 'chomp; push @x,$_ if /./; if(/^$/ or eof){print join("|",@x); @x=()}' f9
switch A|port 2/6|port 2/7|port 3/8
switch B|port 1/2|port 1/5
switch C|port 3/1|port 3/2|port 3/3|port 3/4
$
$

tyler_durden
Last edited by durden_tyler; 03-17-2010 at 05:09 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

column to rows based on another column...

Guys, i have a file in below format where the barcode's are uniq per site but could be repeated for different site. so i want to convert the site column to rows based on the barcode's as below output. your help is appreciated!!! input: SITE BARCODE QTY SP CP 10001 6281103890017 10 50 48... (5 Replies)
Discussion started by: malcomex999
5 Replies

2. UNIX for Dummies Questions & Answers

How to sum rows in e.g. column 1 by a category in e.g. column 2

Hi, I've shown an example of what I would like to achieve below. In the example file, I would like to sum the values in column 2 for each distinct category in column 3 (presumably making an array?) and print the sum as well as the category name and length (note:length always corresponds with... (8 Replies)
Discussion started by: auburn
8 Replies

3. Shell Programming and Scripting

Rows to Column

I have a tab delimited file like this: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 I want it to look like: 1 7 13 2 8 14 3 9 15 4 10 16 5 11 17 6 12 18 (3 Replies)
Discussion started by: theawknewbie
3 Replies

4. UNIX for Dummies Questions & Answers

Rows to column

Hi, i have a file which contains below records: aa bb cc My required output is aa,bb,ccI have achieved this using,awk '{ORS=",";print $0}' file| sed -e "/.$/d" Is there any other solution for this other than awk? (3 Replies)
Discussion started by: pandeesh
3 Replies

5. 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 (4 Replies)
Discussion started by: kokoro
4 Replies

6. UNIX for Dummies Questions & Answers

get max value every 4 rows between 2 column

Hi all I have a file that has two columns and I need the maximum value in column 2 of 4 positions o rows. for example at position {1..3} there are 4 characters (A, C, G and T) each of these characters with a value with a value in column 2. I need the maximum value in column 2 and the corresponding... (2 Replies)
Discussion started by: xinox
2 Replies

7. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies

8. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies

9. UNIX for Dummies Questions & Answers

[Solved] Deleting all rows where the first column equals the second column

Hi, I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks! Input: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output: 1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies

10. Shell Programming and Scripting

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

Dear fellows, I need your help. I'm trying to write a script to convert a single column into multiple rows. But it need to recognize the beginning of the string and set it to its specific Column number. Each Line (loop) begins with digit (RANGE). At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies

LEARN ABOUT OPENSOLARIS

scconf_transp_adap_sci

scconf_transp_adap_sci(1M)				  System Administration Commands				scconf_transp_adap_sci(1M)

NAME

       scconf_transp_adap_sci - configure the sci cluster transport adapter

DESCRIPTION

       Note -

	 Beginning  with  the Sun Cluster 3.2 release, Sun Cluster software includes an object-oriented command set. Although Sun Cluster software
	 still supports the original command set, Sun Cluster procedural documentation uses only the object-oriented command set. For more  infor-
	 mation about the object-oriented command set, see the Intro(1CL) man page.

       You can configure sci SCI-PCI adapters as cluster transport adapters. These adapters can be used with the dlpi transport type.

       The adapter name is sciN, for example, sci0. Do not use scidN as the adapter name.

       An  sci	adapter can only be connected to another sci adapter or to an SCI switch. When an sci adapter is connected to an SCI switch, it is
       important that you specify the correct port name when referring to a port on the switch as an endpoint argument to the scconf or  scinstall
       utility.  The port name must match the port number on the SCI switch (the number that is printed on the switch itself). Failure to give the
       correct port name could result in the operation failing. The result of providing an incorrect port name will be the same as you	would  see
       if the cable between the adapter and the switch were removed.

       There are no user-configurable properties for cluster transport adapters of this type.

SEE ALSO

       Intro(1CL), clinterconnect(1CL), clnode(1CL), scconf(1M), scconf_transp_jct_dolphinswitch(1M), scinstall(1M)

Sun Cluster 3.2 						    4 May 2006						scconf_transp_adap_sci(1M)
All times are GMT -4. The time now is 12:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy