eitsupi commented on issue #34291: URL: https://github.com/apache/arrow/issues/34291#issuecomment-1440028023
@elgabbas Glad you have found a solution. > Using `quote = ""`, I was able to overcome this specific issue, but this is how the data look like now (which is not neat!): > > ``` > Occ <- read_delim_arrow(file = "https://github.com/apache/arrow/files/10804095/Arrow_parse_Example4.txt", delim = "\t", quote = "") > # A tibble: 2 × 3 > # V1 V2 V3 > # 2417934775 "TEXT1\"\"NoQuoted\"\" TEXT2" 49.6 > # 2417934775 "\"TEXT1 \"\"Quoted\"\" TEXT2" 49.6 > ``` > > I think I am close to an acceptable answer! The question now is how to avoid the resulting escape backslash! I suspect this is just tibble escaping the double quotes on the display for clarity. When it is not tibble, it will appear like this. Is this what you are looking for? ```r > read_delim_arrow(file = "https://github.com/apache/arrow/files/10804095/Arrow_parse_Example4.txt", delim = "\t", quote = "") |> as.data.frame() V1 V2 V3 1 2417934775 TEXT1""NoQuoted"" TEXT2 49.6275 2 2417934775 "TEXT1 ""Quoted"" TEXT2 49.6275 ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
