Search code examples
rfwritefixed-width

Why write.fwf() did not follow the fixed width set


I want to write a set of randomly generated numbers to a text file with fixed format. But for some reasons, write.fwf only wrote the 1st column right, all other columns got one extra digit. How can I fix it? Thanks!

    set.seed(1899)

    library(sensitivity)
    library(randtoolbox)

    par_lower <- c( 0.12,  0.13, 0.038, 0.017)
    par_upper <- c(12.00, 13.00, 3.800, 1.700)

    sample_size <- 5

    lim_para8 <- c(par_lower[1], par_upper[1])
    lim_para9 <- c(par_lower[2], par_upper[2])
    lim_parb8 <- c(par_lower[3], par_upper[3])
    lim_parb9 <- c(par_lower[4], par_upper[4])

    par_rand <- parameterSets(par.ranges = list(lim_para8, lim_para9,
                                                lim_parb8, lim_parb9),
                              samples = sample_size, method = "sobol")

    par_rand

    # write to file
    library(gdata)
    file2write <- paste("par.txt", sep = "")
    write.fwf(par_rand, file = file2write, width = c(10, 10, 10, 10), colnames = FALSE)

The results:

     6.060    6.56500    1.91900   0.858500
     9.030    3.34750    2.85950   0.437750
     3.090    9.78250    0.97850   1.279250
     4.575    4.95625    2.38925   0.227375
    10.515   11.39125    0.50825   1.068875

If I changed to

    write.fwf(par_rand, file = file2write, width = c(10, 9, 9, 9), 
              colnames = FALSE, quote = FALSE, rownames = FALSE)

I got this error

    Error in write.fwf(par_rand, file = file2write, width = c(10, 9, 9, 9),  : 
      'width' (9) was too small for columns: V4
     'width' should be at least (10)

Solution

  • Please try the code below, it works for me. I tested with several formats and all worked. Both code segments return a fixed format file with width 4 x 10.

    This of course implies that setting sep in the definition of file2write does not work for getting the desired output with write.fwf

    write.fwf(par_rand, file = "par2.txt", width = c(10, 10, 10, 10), colnames = FALSE, sep = "")
    
    write.fwf(par_rand, file = file2write, width = c(10, 10, 10, 10), colnames = FALSE, sep = "")
    

    The following generates the same but with 1x10 and 3x9, as I think you wanted

    write.fwf(par_rand, file = "par3.txt", width = c(10, 9, 9, 9), colnames = FALSE, sep = "")
    

    Please let me know whether this is what you wanted.