Convert delimited text lines to data.frame. Blank lines are always skipped, trailing whitespaces are trimmed. You can use comments with '#' inside your text. For details see read.table.
text_to_columns(
text,
header = TRUE,
sep = "",
quote = "",
dec = ".",
encoding = "unknown",
...
)text_to_columns_csv(
text,
header = TRUE,
sep = ",",
quote = "",
dec = ".",
encoding = "unknown",
...
)
text_to_columns_csv2(
text,
header = TRUE,
sep = ";",
quote = "",
dec = ",",
encoding = "unknown",
...
)
text_to_columns_tab(
text,
header = TRUE,
sep = "\t",
quote = "",
dec = ".",
encoding = "unknown",
...
)
text_to_columns_tab2(
text,
header = TRUE,
sep = "\t",
quote = "",
dec = ",",
encoding = "unknown",
...
)
data.frame
character/vector of characters
a logical value indicating whether the text
contains the
names of the variables as its first line.
the field separator character. Values on each line of the file are
separated by this character. If sep = "" (the default for text_to_columns
) the
separator is 'white space', that is one or more spaces, tabs, newlines or
carriage returns.
the set of quoting characters. To disable quoting altogether, use quote = "".
the character used in the file for decimal points.
encoding to be assumed for input strings. It is used to mark character strings as known to be in Latin-1 or UTF-8 (see read.table).
further parameters which will be passed to read.table.
text_to_columns("
# simple data.frame
a b c
1 2.5 a
4 5.5 b
7 8.5 c
")
Run the code above in your browser using DataLab