I already posted this on askdifferent, but no luck. Glad to remove if out of scope.
So I am running some Python scripts that print out tab-delimited data (i.e. adding the
\t character during the
- I am trying to copy that tab-delimited data from the shell / Terminal into Excel Mac or other spreadsheet applications, hoping they would recognize the tab-delimination and put the items into separate cells
This does not work; however, if I copy the text into an editor such as Atom or Emacs first, and then into Excel, it recognizes the tabs as delimiters.
- Why does it work with the additional step?
- Do the text editors change the nature of the tabs, and how can I emulate this behavior within the Terminal?
Copy from Terminal into Excel:
Copy from Terminal to Text Editor, then into Excel:
Any help is much appreciated! I know there are more elegant ways of doing this, but this is still something I'd like to figure out.
I found a somewhat similar, but unresolved question here.
Running Python 2.7.13 , Sierra 10.12.6, Excel 2016 for Mac