Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How can i transpose this rerult by using awk?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How can i transpose this rerult by using awk?
# 1  
Old 05-07-2010
How can i transpose this rerult by using awk?
From>>>
ATOM 1 ca 2 o 3 h 4 h 5 o
dE/dx 0.2057422D-01 0.2463722D-01-0.1068047D-01-0.1495280D-01-0.3725362D-02
dE/dy -0.7179106D-02-0.1554542D-01 0.1016889D-01 0.3268502D-02-0.4888578D-01
dE/dz -0.5600872D-02 0.3110649D-01-0.4088230D-02-0.2295107D-01-0.2832048D-01
ATOM 6 h 7 h 8 o 9 h 10 h
dE/dx 0.9525615D-02-0.9503037D-02 0.1689507D-01 0.7277895D-03-0.2111557D-01
dE/dy 0.3902392D-01 0.1220264D-01 0.5837539D-01-0.1350591D-02-0.6110345D-01
dE/dz 0.2086767D-01 0.1308971D-01 0.4212211D-01-0.3857783D-02-0.3506507D-01
ATOM 11 o 12 h 13 h 14 o 15 h
dE/dx -0.1542481D-01 0.9872019D-02-0.2025238D-02 0.6888561D-02 0.1057477D-01
dE/dy -0.1334465D-01 0.3666496D-02 0.1088555D-01 0.2137170D-01-0.6013097D-02
dE/dz 0.2977948D-01-0.1278534D-01-0.1272541D-01 0.4976557D-02-0.5361850D-03
ATOM 16 h 17 o 18 h 19 h 20 o
dE/dx -0.1607803D-01-0.4466439D-02-0.8633477D-02 0.1463235D-01-0.1256357D-01
dE/dy -0.1357829D-01-0.2266521D-01 0.4109669D-01-0.4789354D-02-0.3342545D-01
dE/dz -0.6053460D-02-0.3893747D-02-0.1146559D-01 0.1447851D-01 0.2771696D-01
ATOM 21 h 22 h 23 o 24 h 25 h
dE/dx 0.1159822D-02 0.6070351D-02 0.8284857D-02-0.6641931D-03-0.1313546D-01
dE/dy 0.1192183D-01 0.1009477D-01-0.5001876D-02-0.2469536D-02 0.1214988D-01
dE/dz -0.3776217D-01 0.4180746D-02 0.5491223D-02 0.2433015D-02-0.8376573D-02
ATOM 26 o 27 h 28 h 29 o 30 h
dE/dx 0.1103057D-01-0.1328518D-01 0.9606614D-02 0.3365380D-02 0.4944141D-02
dE/dy -0.1885375D-01 0.2136716D-01-0.2015923D-03 0.1388877D-01-0.5653677D-02
dE/dz 0.2716471D-01-0.3088887D-01-0.2871229D-02-0.8382806D-03 0.3075100D-02
ATOM 31 h
dE/dx -0.1252600D-01
dE/dy -0.8830054D-02
dE/dz 0.1604802D-02
TO>>>
1 ca 0.2057422D-01 -0.7179106D-02 -0.5600872D-02
2 o 0.2463722D-01 -0.1554542D-01 0.3110649D-01
3 h -0.1068047D-01 0.1016889D-01 -0.4088230D-02
4 h -0.1495280D-01 0.3268502D-02 -0.2295107D-01
etc..

Thank you very much
wan
# 2  
Old 05-07-2010
By reading the answer given in your original thread. Thread closed.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Transpose table with awk

I am trying to format the table below to the output input: cand week sub1 sub2 sub3 sub4 joe 1 94.19 70.99 43.93 60.14 joe 2 94.07 51.02 41.07 38.92 joe 3 26.24 30.95 44.56 67.67 joe 4 72.36 60.92 40.78 83.25 joe 5 51 70.01 44.66 82.22... (7 Replies)
Discussion started by: aydj
7 Replies

2. Shell Programming and Scripting

Transpose using awk

Hi Friends, Very urgent requirement please do needful ASAP.. Input: |1||1|1||1|3||3|2||2|4||4|2||2|3||3|NA||0|5||5|NA||0|4||4|3||3 output: |1||1 |1||1 |3||3 |2||2 |4||4 |2||2 |3||3 |NA||0 |5||5 (4 Replies)
Discussion started by: bharat1211
4 Replies

3. Shell Programming and Scripting

Transpose data as rows using awk

Hi I have below requirement, need help One file contains the meta data information and other file would have the data, match the column from file1 and with file2 and extract corresponding column value and display in another file File1: CUSTTYPECD COSTCENTER FNAME LNAME SERVICELVL ... (1 Reply)
Discussion started by: ravlapo
1 Replies

4. Shell Programming and Scripting

awk to transpose every 7 rows into columns

input: a1 a2 a3 a4 a5 a6 a7 b1 b2 b3 .. b7 .. z1 .. z7 (12 Replies)
Discussion started by: ux4me
12 Replies

5. Shell Programming and Scripting

Transpose column to row - awk

Hi there, I have a small csv file example below: source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512 I want to transpose columns to rows starting at the second... (3 Replies)
Discussion started by: theflamingmoe
3 Replies

6. Shell Programming and Scripting

Complex transpose awk script

Hello to all in forum, Maybe an awk expert could help me with this complex task for me. I have the input shown below and I would like to get the output as follow: - I would like the output separated by commas. - The header is fixed and will be the same always. - For the lines containing... (22 Replies)
Discussion started by: Ophiuchus
22 Replies

7. Shell Programming and Scripting

awk transpose rows to column

Need to transpose in awk rows to column like this: input: A1,6,5,4 3,2,1, A2,8,7,9,10,11,12,13,14 A3,1,2,3,5,7,8,9 A4,9,4,8,1,5,3, output: A1,1 A1,2 A1,4 ... A2,7 A2,8 ... A3,1 A3,2 ... A4,1 A4,3 (5 Replies)
Discussion started by: sdf
5 Replies

8. Shell Programming and Scripting

Transpose using awk

I have a requirement to transpose the below xml which is in a text file on unix: <?xml version="1.0" ?> <REQUEST> <ID>XXX</ID> <TIMESTAMP>20090720062610</TIMESTAMP> <FLAG>Y</FLAG> <TO_FLAG>Y</TO_FLAG> </REQUEST> to <?xml version="1.0"... (13 Replies)
Discussion started by: new_ds_man
13 Replies

9. Shell Programming and Scripting

How to transpose a table of data using awk

Hi. I have this data below:- v1 28 14 1.72414 1.72414 1.72414 1.72414 1.72414 v2 77 7 7.47126 6.89655 6.89655 6.89655 6.89655 v3 156 3 21.2644 21.2644 20.6897 21.2644 20.6897 v4 39 3 1.72414 1.72414 1.72414 1.72414 1.72414 v5 155 1 21.2644 23.5632 24.1379 23.5632 24.1379 v6 62 2 2.87356... (2 Replies)
Discussion started by: ahjiefreak
2 Replies

10. Shell Programming and Scripting

How to transpose data elements in awk

Hi, I have an input data file :- Test4599,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,2,Rain Test90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,Not Rain etc.... I wanted to transpose these data to:-... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
Login or Register to Ask a Question