‘Embedded nul in string’ error when importing csv with fread

by

We can remove the null terminators on the command line using something like:

sed 's/\\0//g' mycsv.csv > mycsv.csv

Or as suggested by @marbel, fread allows you to pass the sed call inside the text. Such as:

fread("sed 's/\\0//g' mycsv.csv")

More Related Contents:

  1. Reason behind speed of fread in data.table package in R
  2. Is there a dplyr equivalent to data.table::rleid?
  3. Assign multiple columns using := in data.table, by group
  4. Efficient way to rbind data.frames with different columns
  5. How to replace NA values in a table for selected columns
  6. data.table “key indices” or “group counter”
  7. Select subset of columns in data.table R [duplicate]
  8. R: data.table cross-join not working
  9. Why is allow.cartesian required at times when when joining data.tables with duplicate keys?
  10. Dynamically build call for lookup multiple columns
  11. Select values from different columns based on a variable containing column names [duplicate]
  12. eval and quote in data.table
  13. Efficiently computing a linear combination of data.table columns
  14. When should I use the := operator in data.table?
  15. Subsetting data.table by 2nd column only of a 2 column key, using binary search not vector scan
  16. Using dynamic column names in `data.table`
  17. Conditional binary join and update by reference using the data.table package
  18. How do you delete a column by name in data.table?
  19. How does one change the levels of a factor column in a data.table
  20. When should I use setDT() instead of data.table() to create a data.table?
  21. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  22. In R data.table, how do I pass variable parameters to an expression?
  23. Merging two sets of data by data.table roll=’nearest’ function
  24. Using data.table i and j arguments in functions
  25. R data.table breaks in exported functions
  26. Applying a function to each row of a data.table
  27. Empty factors in “by” data.table
  28. How to use data.table within functions and loops?
  29. What you can do with a data.frame that you can’t with a data.table?
  30. data.table: anonymous function in j

Leave a Comment