Excel table, meet Jira :-). After writing the previous AutoHotkey script to convert the clipboard contents to a comma separated list, I wrote this one. It makes constructing Jira tables a breeze.
;;; Converts a copied table from Excel into Jira format
#+j::
StringReplace, ForFirstLine, Clipboard, `r`n, §
StringSplit, ForFirstLine, ForFirstLine, §
StringReplace, ForFirstLine1, ForFirstLine1, %A_Tab%, ||, All
StringReplace, ForFirstLine2, ForFirstLine2, %A_Tab%, |, All
ForFirstLine2 := RTrim(ForFirstLine2, "`r`n")
StringReplace, ForFirstLine2, ForFirstLine2, `r`n, |`r`n|, All
Clipboard := "||" . ForFirstLine1 . "||`r`n|" . ForFirstLine2 . "|"
Send ^v
Return
To use it, just press Windows+Shift+J (but that's easily changed). It puts double pipes on the first line, and single pipes on other lines.
Genius - this has just saved me a lottttttta time.
ReplyDeletemuch appreciated.
Thanks for the appreciate rav124 :-D. I'm always happy to hear something I've written is being used.
ReplyDeleteP.S. While I'm here - for others using the script, it works best if it's saved as a Unicode text file because of the "§".
how do you add this to JIRA exactly ? this piece of code is to be put somewhere i guess but where exactly ?
ReplyDeleteanyone looking at this page ?
ReplyDeleteHi sileclercq
ReplyDeleteYou need to download and use the program at http://www.autohotkey.com
Then replace the code in the example file with the code above.
//Kasper
I am getting an error for call to non existent function
ReplyDelete--> ForFirstLine2 := RTrim(ForFirstLine2, "`r`n")
This comment has been removed by the author.
DeleteYou're using an older version, get the new one here: http://ahkscript.org/
ReplyDeleteExcel 2003 introduced a neat feature for helping anyone enter data easily and quickly with the arrival of the "list". excel dashboard software
ReplyDeleteHowever, there are detailed macros and scripts which are essential in making the critical financial and business decision right at a point of time.salesforce custom dashboard
ReplyDelete