Tags:
create new tag
, view all tags

Question

I've looked through SpreadSheetPlugin. I want the reverse of PROPERSPACE - I want to convert a string of blank-separated words into a Wiki Word.

TRIM won't remove spaces between words TRANSLATE will replace the spaces with _ but doesn't seem to have an option to replace the with nothing LISTJOIN doesn't appear to recognize a null separator.

Is there something I haven't seen? Or is this a feature request for Spreadsheet plugin?

Environment

TWiki version: TWikiRelease04x00x05
TWiki plugins: DefaultPlugin, EmptyPlugin, InterwikiPlugin
Server OS:  
Web server:  
Perl version:  
Client OS:  
Web Browser:  
Categories: Missing functionality

-- VickiBrown - 03 May 2007

Answer

ALERT! If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Hm, is this a subset of HowToDeleteCharactersFromAString?

-- FranzJosefSilli - 03 May 2007

Although tricky, it might be possible to do that with a number of CALC functions. Basically you need to capitalize characters after spaces, then remove the spaces.

A new $MAKEWIKIWORD() function could be added to the plugin.

-- PeterThoeny - 08 May 2007

I think a MAKEWIKIWORD function would be useful

-- VickiBrown - 21 May 2007

re: a number of CALC functions, I'm guessing this could be done by first using PROPER, then the magic Peter posted at Support.HowToDeleteCharactersFromAString

Of coourse, I also think a MAKEWIKIWORD funcction would be valuable.

-- VickiBrown - 19 Jul 2007

Change status to:
Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r5 - 2007-07-19 - VickiBrown
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.