Wednesday, May 13, 2009 12:12 PM | rahel luethy | 3 comment(s)
mostly a note to myself, but this maybe comes in useful to others:
- export excel table as tab-separated values
- open in any text editor with regular expression support
- replace \t with | (inserts column boundaries)
- replace ^(.*)$ with |\1| (pre-/appends boundaries for first/last column)
- replace || with | | (inserts a space for empty columns; run again if the previous run produced new pairs)
2:13 PM | Ced said...
Or just paste it in RTF-mode and it will be converted automagically.
2:20 PM | rahel luethy said...
thanks for the pointer -- only works with wikis that actually offer an RTF-mode though (which e.g. jira does not...)
3:50 PM | Ced said...
That's true. :-( It has been a long-standing feature request to include a Confluence-like editor in Jira, though (see http://jira.atlassian.com/browse/JRA-8943).
