is there any way to …

Post bug reports and suggestions for PlanMaker 2010 for Linux.

Moderator: SoftMaker Team

Post Reply
engine
Posts: 101
Joined: Tue Mar 20, 2007 11:29 am
Location: Belgium

is there any way to …

Post by engine » Fri May 13, 2011 3:28 pm

I'm asking the question cautiously, because I don't know whether it's a standard spreadsheet function ‒ I use a spreadsheet as a tool for manipulating large amounts of tabular text, not for calculations.

Anyway, here's the question: if I have a cell that contains (for example) a list of filenames separated by semicolons, is there any easy way to move each filename in the list to a cell by itself? I can do it by exporting to .txt, manipulating the text file in vim and then reimporting, but I'd prefer to be able to do it within the spreadsheet.

Any ideas gratefully received!
Niels Grundtvig Nielsen
You know what you're talking about ‒ I can help you say it
http://www.kbss27.be

Jossi
SoftMaker Volunteers
SoftMaker Volunteers
Posts: 896
Joined: Fri Dec 05, 2003 10:47 pm
Location: Luebeck, Germany

Re: is there any way to …

Post by Jossi » Fri May 13, 2011 6:23 pm

Hi Niels,

I think I've figured out a way (see attached file).
To let the formula not grow too complicated, I have added two auxiliary columns (C and D).
This formula can be used for any number of filenames listed in A1, just pull the small square in the lower right corner of B10, C10 and D10 further down.
There's only one little glitch left: You must close the filelist in A1 with a double semicolon (;;), else the last two cells will be wrong.

Cheers
Jossi
Attachments
splitfilenames.pmd
(24.5 KiB) Downloaded 227 times

engine
Posts: 101
Joined: Tue Mar 20, 2007 11:29 am
Location: Belgium

Re: is there any way to …

Post by engine » Wed Jun 01, 2011 10:02 am

Looks good! thanks, Jossi

N
Niels Grundtvig Nielsen
You know what you're talking about ‒ I can help you say it
http://www.kbss27.be

Post Reply

Return to “PlanMaker 2010 for Linux”