Shell Programming and Scripting

Hi,

I have to reshape some ascii files. I have many ascii files that have collapsed the lower triangular of my matrix into row. I simply want to convert them back to the proper matrix form. So, my current data looks like this:

Code:

11 21 22 31 32
33 41 42 43 44
...

This is five columns of data for an 88x88 matrix. And I want to make it look like this:

Code:

11,.,.,.,.,.,.,.,.,.,.,.,. (...88 columns)
21,22,.,.,.,.,.,.,.,.,.,.
31,32,33,.,.,.,.,.,.,.,.
41,42,43,44,.,.,.,.,.,.
51,52,53,54,55,.,.,.,.
61,62,63,64,65,66,.,.
...
(88 rows)

I want to use awk for this, but really am a novice (and a social scientist). I suspect this is simple, but am at a loss with writing the algorithim in awk.
Any help will be hugely appreciated.

Thanks very much.
--VH

Try...

Code:

paste -s file1|gawk '{for(x=1;x<=n;x++)for(y=1;y<=n;y++)printf (y<=x?$(++c):".") (y==n?ORS:",")}' n=88

That set me up perfectly. After some tinkering, I found my solution.