'R : Strange output from read_tsv(), 0 rows and 21467349 columns

Does anyone know what type of charachter is this? I'm tryin to import this file in my R Session. The columns are tab separated (actually it looks to me that some are separated with 1 tab and others with 2 tabs) but when i open this plain text file in my editor it shows these "up arrows".

here a portion of the file:

the file is 184.686 kB

my code in a new started R session is:

> library(tidyverse)
-- Attaching packages -------------------------------- tidyverse 1.3.1 --
√ ggplot2 3.3.5     √ purrr   0.3.4
√ tibble  3.1.6     √ dplyr   1.0.8
√ tidyr   1.2.0     √ stringr 1.4.0
√ readr   2.1.2     √ forcats 0.5.1
-- Conflicts ----------------------------------- tidyverse_conflicts() --
x dplyr::filter() masks stats::filter()
x dplyr::lag()    masks stats::lag()

> path_T11 <- "Einzelteil/Einzelteil_t11.txt"
> T11 <- read_tsv(path_T11)
Error: The size of the connection buffer (131072) was not large enough
to fit a complete line:
  * Increase it by setting `Sys.setenv("VROOM_CONNECTION_SIZE")`

# Sys.setenv("VROOM_CONNECTION_SIZE" = 180000000) still generates error so i go up with
> Sys.setenv("VROOM_CONNECTION_SIZE" = 190000000)
> T11 <- read_tsv(path_T11)
New names:                                                                                                             
* `1` -> `1...10`
* `215` -> `215...12`
* `2154` -> `2154...13`
* `0` -> `0...14`
* `NA` -> NA...15
* ...
Rows: 0 Columns: 21467349
-- Column specification -------------------------------------------------------------------------------------------------
Delimiter: "\t"
chr (21467349): X1, ID_T11, Herstellernummer, Werksnummer, Fehlerhaft, Fehlerhaft_Datum, Fehlerhaft_Fahrleistung, Pro...

i Use `spec()` to retrieve the full column specification for this data.
i Specify the column types or set `show_col_types = FALSE` to quiet this message.
> spec(T11)
#runs too long without giving any output and i stopped my R Session

After the file was wrongly "imported" i noticed that my R Session was using 16GB of memory:

Status of RStudio after the wrong import. System is using 16GB of memory

i am new to RStudio and R. I used read_tsv() because i thought the file was tab separated. I don't know if this problem (hence it says there are 0 rows) is due to the "up arrow" or the tab delimiter. I will be pleased if someone can give me an in depth overview of what's happening, and why the import was not succesfull. I would also like to know why my R session is taking up so much memory.

EDIT: it seems to me that columns are tab separated and rows are "up-arrow" separated. I say this, because the file on my macbook (textedit) looks like this: on mac: enter image description here

on windows: start of the file: beginning of file on windows end of file: end of file on windows

EDIT: using the UTF-8 Tool to identify the "up-arrow" charachter as mentioned in the comments result in this: UTF-8 Tool output Thank you in advance !



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source