The Omni Group Forums

The Omni Group Forums (http://forums.omnigroup.com/index.php)
-   OmniOutliner 3 for Mac (http://forums.omnigroup.com/forumdisplay.php?f=9)
-   -   give columns an indent (http://forums.omnigroup.com/showthread.php?t=14829)

marcussommer@mac.com 2009-12-21 07:52 AM

give columns an indent
 
hi to all

have a spreadsheet which displays characteristics of certain essential oils written right next to the name of the oil itself, thus looking like that:

oil01 "name in latin01" "general system affected01"
oil02 "name in latin02" "general system affected02" ..

which I would need now in an indented form:

oil01
"name in latin01"
"general system affected01"

oil02
"name in latin02"
"general system affected02" ..

Spreadsheet is available in XLS or tab-separeted TXT format

Q: does anybody know of a script / utility inside or outside OO that would allow me to convert the file accordingly?

whpalmer4 2009-12-21 02:01 PM

1 Attachment(s)
Find attached a little Applescript that converts all the columns beyond the topic column into children rows, then deletes the columns. You can open your tab-delimited spreadsheet in OO, then run this script and get what you requested.

marcussommer@mac.com 2009-12-22 06:27 AM

[QUOTE=whpalmer4;70953]Find attached a little Applescript that converts all the columns beyond the topic column into children rows, then deletes the columns. You can open your tab-delimited spreadsheet in OO, then run this script and get what you requested.[/QUOTE]
worked like a charm.
many thanks!


All times are GMT -8. The time now is 07:37 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.