Keep leading zeros with colsplit in R

Question

I'm using colsplit to split a large string to columns.
there are numbers in the string with leading zeros.
How can I prevent colsplit from converting them to numeric values?

Example:
value in string: 0000122517
after colsplit this becomes: 122517

I need the leading zeros, and the values can be of any length, so I
cannot add the zeros afterwards.

Kind regards, Oene Douma

Can you provide a small reproducible example and expected output — akrun, Oct 28 '16 at 13:06
str <- "Client~0000122517" colsplit(str, split = "~", names = " ") Returns: X. NA. 1 Client 122517 this should be: X. NA. 1 Client 0000122517 — Oene Douma, Oct 28 '16 at 13:12
Try with `read.table` i.e. `read.table(text=str, sep="~", header=FALSE, colClasses = c("character", "character"))` — akrun, Oct 28 '16 at 13:14

score 1 · Accepted Answer · answered Oct 28 '16 at 14:58

1

We can use read.table

read.table(text=str, sep="~", header=FALSE, colClasses = c("character", "character"))

answered Oct 28 '16 at 14:58

akrun

874,273
37
540
662

Keep leading zeros with colsplit in R

1 Answers1