Read SQL Microft Exported File 2016

Question

I received a file exported from Microsoft SQL 2016 that has extension . txt and the same with . csv and has this face:

​ I searched, but I haven’t found anything yet, someone has some experience importing that file to R?

A simple read.csv for example does not work

Answer 1

In theory, any. txt file can be imported into the R. Try to rotate the command

dados <- read.table(file="NomeDoArquivo.txt", header=TRUE, sep="\t")

in which

• file="NomeDoArquivo.txt" is the file name to be imported

• header=TRUE informs that NomeDoArquivo.txt has a header. If NomeDoArquivo.txt does not have header, change the argument to header=FALSE

• sep="\t" is the column separator of the file. How read.csv is not working, I guess the column separator is a tab tag. Other common options for sep sane ,, ; and " " (space).

Finally, turn

dim(dados)
str(dados)

and see if the number of rows and columns reported is as expected and if the data type in each column is correct. If all goes well, the data set has been imported correctly. If it doesn’t work (or if the above code doesn’t work), come back here and we’ll try to figure out what to do together.