0

I have been trying to import data from a DAT file but the text is separated by white rectangles, looks like "25af" characters but R doesn't recognise this as a separator.

Has anyone encountered this before? This file is encoded via ANSI if this helps?

Thanks in advance

1 Answers1

0

You could try this:

read.csv(text = gsub("\u25af", ",", readLines("my_file.dat", encoding = "UTF-8")))
Allan Cameron
  • 147,086
  • 7
  • 49
  • 87