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