More than transposing!


 
Thread Tools Search this Thread
Special Forums UNIX Desktop Questions & Answers More than transposing!
# 1  
Old 04-11-2008
More than transposing!

Hi everyone,

I have a poblem like that:

I have a file which includes data looks like:

0.65214 0.3597 1.0
0.65244 0.3502 1.0
0.65273 0.3553 1.0
0.65305 0.3544 1.0
0.65327 0.3505 1.0
0.65359 0.3516 1.0
0.65578 0.6464 1.0
0.65605 0.6453 1.0
0.65633 0.6437 1.0
0.65660 0.6488 1.0
0.65688 0.6435 1.0
0.65716 0.6432 1.0
...
...
I have to convert this data to:

0.65214 0.35971.00.65244 0.35021.00.65273 0.35531.00.65305 0.35441.00.65327 0.35051.0
0.65359 0.35161.00.65578 0.64641.00.65605 0.64531.00.65633 0.64371.00.65660 0.64881.0
...
...

Yes, there is no "space" between some values. As you see, five row must convert to one row in given format.

I tried very much, but I could not get it.

Any suggestions?

Regards,
B.
# 2  
Old 04-11-2008
Code:
awk ' { printf("%s", $0)
          if(NR%5 == 0) {printf("\n")}
      ' oldfile > newfile

# 3  
Old 04-11-2008
Thanks.

It's very fast.

But it gives the error:

Code:
bulash@linux-sb6k:~/phoebe_data/TZ_Eri> awk ' { printf("%s", $0)
> if(NR%5 == 0) {printf("\n")}
> ' B.txt > A.dat

awk: cmd. line:3: if(NR%5 == 0) {printf("\n")}
awk: cmd. line:3:                             ^ unexpected newline or end of string

Is it normal?

Best wishes,
B.

Last edited by bulash; 04-11-2008 at 05:43 PM..
# 4  
Old 04-11-2008
OK it works very well...

Thanks indeed again.

B.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

[Solved] Matching and transposing

Hi, I've got two files. files one: AAMP 2:219129783:A:G AAMP 2:219129896:A:G AAMP 2:219130802:T:C AANAT 17:74464865:T:G AANAT 17:74464914:A:G AANAT 17:74464920:T:C file 2: AAMP AANAT I need to create the following file: (2 Replies)
Discussion started by: zajtat
2 Replies

2. Shell Programming and Scripting

transposing lines to columns

Okay folks, here's a question. I tried searching but couldn't find exactly what I needed. I have a text file (excerpt below). This text file is an extract I did from several hundred pages of datasheets using grep so I could look only at the site history for each site. The problem is that... (2 Replies)
Discussion started by: jbrandt1979
2 Replies

3. Shell Programming and Scripting

transposing columns into rows

Hi, I need to transpose columns of my files into rows and save it as individual files. sample contents of the file below. 0.9120 0.7782 0.6959 0.6904 0.6322 0.8068 0.9082 0.9290 0.7272 0.9870 0.7648 0.8053 0.8300 0.9520 0.8614 0.6734 0.7910 0.6413 0.7126 0.7364 0.8491 0.8868 0.7586 0.8949... (8 Replies)
Discussion started by: ida1215
8 Replies

4. Shell Programming and Scripting

Transposing a file

Hi Guys, I have file containing this kind of format below: ======== MOBILITY EVENT (G): ATTACH REJECT ========= Time : <date_time> Node : <node> GMM Cause : <code> Details : <details> Attach : <attach type> IMSI : <imsi> PTMSI : <ptmsi> RA New : <ra new> RA... (9 Replies)
Discussion started by: rymnd_12345
9 Replies

5. Shell Programming and Scripting

Transposing a file

Hi All, I have a input file say FILEA. FILEA -------- empid1 sal1 location1 manager1 empid2 sal2 location2 manager2 empid3 sal3 location3 manager3 . . . (3 Replies)
Discussion started by: 46019
3 Replies

6. Shell Programming and Scripting

Transposing a file

i have a file as: 1 2 3 4 5 i want output as : 1 2 3 4 5 can anybody help on this?? (14 Replies)
Discussion started by: vikas_kesarwani
14 Replies

7. Shell Programming and Scripting

Transposing string

Hello guys, can some please give driection as to how to archieve this big issue i am having: I a random number that has been generated and wants the user to guess it, let me illustrate this: say the random i hve generated is 'nice' - i then hide it from the user and display it in ----... (3 Replies)
Discussion started by: unibboy
3 Replies

8. Shell Programming and Scripting

Another transposing issue

Hello I need to sort a file with data such as so it breaks on column 1 and all the data in column 2 is sorted into rows with a unique column 1: 1 5 1 6 1 7 2 3 2 4 3 7 3 0 3 9 So it comes out as: 1 5 6 7 2 3 4 3 7 0 9 I've tried many iterations of nawk but can't get it... (14 Replies)
Discussion started by: stevesmith
14 Replies

9. Shell Programming and Scripting

file transposing

Hello, Is there a way to transpose a file in shell scripting? For instance, from a1 a2 a3 a4 a5 a6 a7 .... b1 b2 b3 b4 b5 b6 b7 .... c1 c2 c3 c4 c5 c6 c7 .... d1 d2 d3 d4 d5 d6 d7 ... ... ... ... to a1 b1 c1 d1 .... a2 b2 c2 d2 .... a3 b3 c3 d3 .... a4 b3 c3 d4 .... ... ... (24 Replies)
Discussion started by: mskcc
24 Replies

10. Shell Programming and Scripting

transposing letters

Hi, I've written a shell function in bash that reads letters into an array, then outputs them in one column with: for n in "${array}"; do echo $n done I was wondering if anyone knew how i would transpose the letters that are output by the for loop. Right now my output is: aabbcc... (4 Replies)
Discussion started by: myscsa2004
4 Replies
Login or Register to Ask a Question