data.table::fwrite

[DavoWW]

You've got some escape characters (backslashes) in the original -are they causing the problem?

[pferrari27]

I am still not the wiser.

I re-created the data above the same way it was first created. I have since saved it, opened it, binded it to the re-created data and saved it again nine times and there are no additional quotation marks.... stumped.

Thanks to all, at least I knew all I had to do was delete the double quotations to get back to normalcy.

[jrkrideau]

Just to confuse you further, try this on the original data.

DT <- fread("long_char.csv", drop = "r_name")
object.size(DT)
fwrite(DT, "long2.csv")

[pferrari27]

in that file I counted up the

characters in r_name - 90,878,263
double quotations in r_name - 89,915,392