[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [MISC] Findes der ikke en split-lignende funktion i OOCalc?



Umiddelbart findes der Data->Text to Columns funktionen hvis det blot er
en enkelt gang du skal udføre operationen...

Læs hvordan på 

http://www.oooninja.com/2008/01/text-columns-calc-convert-openoffice.html



On Fri, 2009-05-29 at 09:44 +0200, Michael Schmidt wrote:
> Jeg har brug for den omvendte funktion af CONCATENATE
> I PERL findes en split('delimiter',string) = @values
> 
> Men noget tilsvarende lader ikke til at være tilgængligt i OO :(
> 
> Jeg har en celle, der indeholder en komma sepereret liste af  
> værdier(tekst) der skal fordeles i celler.
> 
> Jeg er kommet noget af vejen med LEFT(), MID(), RIGHT() og LEN(), men det  
> er ikke robust nok, da jeg ikke på forhånd kender antallet af elementer i  
> hver liste.
> 
> Nogle gode idéer?
> 
> 



 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2009-06-01, 02:01 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *