Tab delimited text in clipboard is filtered to table markdown. If no tabs are present, then input text is regarded as whitespace delimited. Handy for copy/paste from Excel, query results, etc. to Confluence, Github, etc.
Thanks for sharing. I can really use a macro like this.
Unfortunately, it is not working for me: Vertical bars are missing from some end of lines and beginning of lines. Please advise if I'm not using the macro correctly.
I copied a cell range (3x4) from Excel, a pasted into TextWrangler.
I then ran your macro, and pasted into TW again.
####Before Macro
(the triangles represent TABs in TextWrangler)
####After I ran Macro
|Apr 2017|21|1.19|3.65
Jan 2017|19|1.56|5.03
Dec 2016|19|1.28|2.2|
Depends on the flavor of Markdown. Some do, some don't.
The Discourse forum (used by KM forum) markdown does not support tables (yet)
But the KM Wiki does.
Sorry, I could not reproduce your problem, it should work with your input. Works fine with Libre Office and SQL Developer and I don’t have Excel for testing. Btw, Libre Office or Excel are handy for pasting html tables, then copy, then use the KM macro.
But I read, that the KM only approach works fine for you. Amazing, that KM can do it without any external scripting. What a powerful tool, so much to explore…