Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [Solved] Uneven column to row conversion
Top Forums UNIX for Dummies Questions & Answers [Solved] Uneven column to row conversion Post 302891340 by Leander on Wednesday 5th of March 2014 08:27:26 AM
Old 03-05-2014
[Solved] Uneven column to row conversion
Hi Unix Forum,

I have a relatively easy question i suppose for which, however, until now i could not find a solution.

I am working with a program that will give me an output file similar to the following:
Code:
A
1
2
3
4

B
1
2
3
4

C
1
2
...

As the file is rather long and may variy in length for different files
i need to convert it to the following form:
Code:
A 1 2 3 4 ...
B 1 2 3 4 ...

so that ich can use gnuplot.
So far i have only found solutions for cases like:
Code:
A B 
1 3 
2 4

to
Code:
A 1 2
B 3 4

done with awk.
I sadly am not very familiar with awk or sed commands but i can at least make them work in a simple bash script.

I was hoping for a solution that would do for 1 file something similar to wenn i would have 2 files
Code:
A
1
2

and

B 
1 
2 

and paste them into one file 

A  B 
1  1
2  2

Is there any decent solution for this problem that i could use ?

Notice that the number of lines below A might vary in length.
So far i could only think of somehow scanning from the beginning to the first empty line, then write a file A.dat, continue scanning from this empty line (since B has in reality a similar value to A) to the next line, write B.dat and so on.

Then in the end i could paste all those files togehter in a bashscript, still i would not know how to script something like
Code:
paste fileA fileB ......fileXXX > total.dat

I appologize for the long description. I am not used to using forums for questions but i really would appreciate some help or
tips for tutorials that might prove helpful for this kind of problem.

Alternatively it would of course also be appropriate if it was possible to plot
this format with gnuplot directly though i doubt that.


Greetings
Leander
Last edited by Leander; 03-05-2014 at 09:36 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies

2. Shell Programming and Scripting

column to row conversion with additional pattern

Hi there, I've an input file1 as follows: 1001 1002 1003 1004 1005 I would like to have an output file2 as follows: Numbers are 1001/ 1002/ 1003/ 1004/ 1005/ Any help is appreciated. (2 Replies)
Discussion started by: kbirde
2 Replies

3. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies

4. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

5. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

6. Shell Programming and Scripting

Row to Column conversion?

I have a text file with the geneIds separated by space in each line. The number Ids in lines are different. The file is like: abc qwe tyu ghj jkl dfg sdf cvb sdk fgh tyu uio iop tyu rty eru wer rty iop asd sdf dfg fgh zxc I want to format the file like: abc qwe tyu ghj jkl ... (7 Replies)
Discussion started by: sammy777
7 Replies

7. Emergency UNIX and Linux Support

[Solved] Mysql - Take data from row and copy it to another row

Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :( Dear community, I have a table with two rows like: Row1 Row2 ======= ======= 7,3 text 1 1,3 text 2 1,2,3 blabla What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies

8. Shell Programming and Scripting

[Solved] Convert Row To column

Hi Folks, I am using db2 command -> db2 list tablespace show detail Tablespace ID = 10 Name = TSCDDHLMSUM Type = Database managed space Contents = All permanent data.... (5 Replies)
Discussion started by: ckwan
5 Replies

9. Shell Programming and Scripting

Print row on 4th column to all row

Dear All, I have input : SEG901 5173 9005 5740 SEG902 5227 5284 SEG903 5284 5346 SEG904 5346 9010 SEG905 5400 5456 SEG906 5456 5511 SEG907 5511 9011 SEG908 5572 9015 SEG909 5622 9020 SEG910 5678 5739 SEG911 5739 5796 SEG912 5796 9025 ... (3 Replies)
Discussion started by: attila
3 Replies

LEARN ABOUT DEBIAN

cdk_position

cdk_position(3) 					     Library Functions Manual						   cdk_position(3)

NAME

       cdk_position - curses widget positioning key-bindings

SYNOPSIS

       Position methods for the Cdk widgets allow the user to move the widget around the screen via the cursor/keypad keys.

DESCRIPTION

       The following key bindings can be used to move the widget around the screen.

					    +---------------------------------------------------------------+
					    |Key	       Action					    |
					    +---------------------------------------------------------------+
					    |Up Arrow	       Moves the widget up one row.		    |
					    |Down Arrow        Moves the widget down one row.		    |
					    |Left Arrow        Moves the widget left one column 	    |
					    |Right Arrow       Moves the widget right one column	    |
					    |1		       Moves  the  widget down one row and left one |
					    |		       column.					    |
					    |2		       Moves the widget down one row.		    |
					    |3		       Moves the widget down one row and right	one |
					    |		       column.					    |
					    |4		       Moves the widget left one column 	    |
					    |5		       Centers the widget both vertically and hori- |
					    |		       zontally.				    |
					    |6		       Moves the widget right one column	    |
					    |7		       Moves the widget up one	row  and  left	one |
					    |		       column.					    |
					    |8		       Moves the widget up one row.		    |
					    |9		       Moves  the  widget  up one row and right one |
					    |		       column.					    |
					    |t		       Moves the widget to the top of the screen.   |
					    |b		       Moves  the  widget  to  the  bottom  of	the |
					    |		       screen.					    |
					    |l		       Moves the widget to the left of the screen.  |
					    |r		       Moves the widget to the right of the screen. |
					    |c		       Centers	the  widget  between  the  left and |
					    |		       right of the window.			    |
					    |C		       Centers the widget between the top and  bot- |
					    |		       tom of the window.			    |
					    |Escape	       Returns the widget to its original position. |
					    |Return	       Exits  the  function  and  leaves  the  wid- |
					    |		       getwhere it was. 			    |
					    +---------------------------------------------------------------+
					    +---------------------------------------------------------------+
       The numbers 0-9 are chosen to correspond to the numeric keypad on your terminal.  Cdk does not handle the application mode  keypad  control
       sequences, since those are not defined via terminfo.  To use the numeric keypad you should ensure that it is in normal (or NumLock) mode.

SEE ALSO

       cdk(3), cdk_binding(3), cdk_display(3), cdk_screen(3)

																   cdk_position(3)
All times are GMT -4. The time now is 10:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy