Dear Unix Gurus,

I have a dataset consisting of a number of uneven columns. What I would like to do is fill up the missing rows with an arbitrary text of fixed value so that all columns now have an equal number of rows.

for example, in the sample datafile below...

1.0 1.3 0.25 2.2
2.0 1.1 0.25 3.1
3.0 1.2 0.25 2.1
4.0 1.4 0.25 0.1
5.0 1.5 0.25 0.13
8.0 1.7 0.25 0.16
11.5 4.3 0.25 0.1
-11.5 3.3 0.25 0.15
-12.5 4.3 0.25 0.1
-13.5 1.3 0.25 0.3
-14.5 1.4 0.25 0.2
-15.5 1.7 0.25 0.0
3.5 1.3 0.25 0.11
5.5 1.3 0.25 0.13
    5.3 0.25 0.15
    4.3 0.25 0.17
    2.3      0.11
    3.3      0.16
    1.1      
    1.4      
    1.8

how you wanna generate that arbitrary number??
can you elaborate bit more??

Hi,

I want to insert a pre-defined number, i.e. in this case "-999.99", into all blank rows.

The reason for this is that I want to use the datafile to generate histograms - one for each data column. Problem is the histograms must all have the same number of entries or else my code fails. So I need to insert an arbitrary high number say, 999 or -999 to fill up the blank rows. On generating the histograms I can then select the data I'm interested in using cuts.

Cheers