Problem:

  • MacOS Terminal does not allow use of \t for “tab” delimiter
  • Source file may have one or more separators set as non-tab characters
    • comma ,
    • pipe |
    • etc
  • Functions to read data cannot read/import data if source has multiple different delimiter characters

Solution:

  • Convert source file using sed in terminal (unix) window:
  • Enter tab — <control> v <tab>

sed ‘s/       /|/g’ source_file > destination_file