fwf2csv {descr} | R Documentation |
Convert fixed width formated file into a tab separated one.
fwf2csv(fwffile, csvfile, names, begin, end, verbose = getOption("verbose"))
fwffile |
The fixed width format file. |
csvfile |
The csv file to be created. The fields will be separated by tab characters and there will be no quotes around strings. |
names |
A character vector with column names. |
begin |
A numeric vector with the begin offset of values in the fixed width format file. |
end |
A numeric vector with the end offset of values in the fixed width format file. |
verbose |
Logical: if |
The return value is NULL, but cvsfile
is created if the function is
successful. The file is a text table with fields separated by tabular
characters without quotes around the strings.
This function is useful if you have a very big fixed width formated file to read and read.fwf would be too slow. The C function that does the real job allocates a buffer of 32765 bytes to read the lines of the fixed width formated file, but it will allocate a larger buffer if there is at least one column to be read near the end of the line.
NULL.
Jakson A. Aquino jalvesaq@gmail.com
For an efficient way of reading a csv file, see the function fread() from data.table package.
## Not run: tab <- rbind(c("state", 1, 2), c("municp", 3, 5), c("house", 6, 8), c("cond", 9, 9), c("sex", 10, 10), c("age", 11, 12), c("income", 13, 16)) fwf2csv("example.txt", "example.csv", names = tab[, 1], begin = as.numeric(tab[, 2]), end = as.numeric(tab[, 3])) df <- read.table("example.csv", header = TRUE, sep = "\t", quote = "") ## End(Not run)