Single column into multiple rows


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Single column into multiple rows
# 1  
Old 04-09-2010
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
d 48
e 10

Thanks in advance
# 2  
Old 04-09-2010
Try:
Code:
awk '{getline s; print $0, s}' file

# 3  
Old 04-09-2010
Its only giving me the 2nd column..

my actual file is like
/home/xyz/file1.txt
10:30 20090407
/home/xyz/file2.txt
11:30 20090407
/home/xyz/file3.txt
10:40 20090407
/home/xyz/file4.txt
09:30 20090407

It should giving like
file1.txt 11:30
file2.txt 11:30 .........
# 4  
Old 04-09-2010
try this for your specific requirements

Code:
#!/bin/sh
sed -n '1~2p' file_name >>temp
sed -n '0~2p' file_name >>temp_3
for line in `cat temp`
do
basename `echo $line`>>temp_2
done
paste temp_2 temp_3 |awk '{print $1 " " $2}'
rm -f temp_2 temp_3 temp

Smilie
# 5  
Old 04-09-2010
Quote:
Originally Posted by prachiagra
Its only giving me the 2nd column..

my actual file is like
/home/xyz/file1.txt
10:30 20090407
/home/xyz/file2.txt
11:30 20090407
/home/xyz/file3.txt
10:40 20090407
/home/xyz/file4.txt
09:30 20090407

It should giving like
file1.txt 11:30
file2.txt 11:30 .........
Code:
awk '{sub(".*/","");s=$0; getline; print s, $1}' file

# 6  
Old 04-09-2010
or,

Code:
awk -F "/" '{getline n;split(n,a," ");print $NF,a[1]}' file

Code:
file1.txt 10:30
file2.txt 11:30
file3.txt 10:40
file4.txt 09:30

working for me.
# 7  
Old 04-09-2010
$ awk -F "/" '{getline n;split(n,a," "); print $NF,a[1]}' new
awk: syntax error near line 1
awk: bailing out near line 1


$ cat new
/home/xyz/file1.txt
10:30
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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;... (1 Reply)
Discussion started by: mad3linux
1 Replies

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

3. 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

4. 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... (3 Replies)
Discussion started by: sara.nowreen
3 Replies

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

6. 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 (3 Replies)
Discussion started by: cbm_000
3 Replies

7. Shell Programming and Scripting

Multiple lines in a single column to be merged as a single line for a record

Hi, I have a requirement with, No~Dt~Notes 1~2011/08/1~"aaa bbb ccc ddd eee fff ggg hhh" Single column alone got splitted into multiple lines. I require the output as No~Dt~Notes 1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh" mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies

8. Shell Programming and Scripting

Split single rows to multiple rows ..

Hi pls help me out to short out this problem rm PAB113_011.out rm: PAB113_011.out: override protection 644 (yes/no)? n If i give y it remove the file. But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Discussion started by: sri_aue
7 Replies

9. 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... (3 Replies)
Discussion started by: laknar
3 Replies

10. UNIX for Dummies Questions & Answers

How to convert a single column into several rows and columns?

I have a program which gives me the output as a single column with hundreds of rows like: 213 314 324 324 123 I want to be able to create a new file from this file which allows me to set the number of rows and columns in the new file, i.e. for this example, if I specify 3 rows and 2... (5 Replies)
Discussion started by: ashton_smith
5 Replies
Login or Register to Ask a Question

Featured Tech Videos