Skip to content

[R-Forge #5610] fread: handle multiple whitespace as delimiter #529

Description

@arunsrinivasan

Submitted by: Matthew Forrest; Assigned to: Nobody; R-Forge link

This has come up in forums a couple of times. Basically it would be fantastic to be able to use sep="" in fread to use multiple whitespaces as the separator analogously to how it works in read.table. Sometimes one cannot get away from data files which have multiple spaces as column separators to make it easy for humans to read, but not so much for fread!

I know it is on Matt Dowle's radar since this stackoverflow post (which also has a handy workaround)

http://stackoverflow.com/questions/22229109/r-data-table-fread-command-how-to-read-large-files-with-irregular-separators

but I thought I would formalise it into a feature request here. Also, thanks for data.table, it is great!

Activity

  1. added this to the v1.9.6 milestone on Sep 8, 2015
  2. arunsrinivasan commented on Sep 16, 2015

    @arunsrinivasan
    MemberAuthor

    Fixed in devel. Please upgrade and test.

  3. juanpide commented on Jul 21, 2016

    @juanpide

    Hello.
    What about handling mixed separators as if they where just one?
    for example sometimes the file has tabs and spaces.

  4. complexgenome commented on Oct 22, 2020

    @complexgenome

    for example sometimes the file has tabs and spaces.

    Is there a way this could be achieved in data.table? data.table_1.13.0 and R4.0
    thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions