You are here: Foswiki>Tasks Web>Item9343 (04 Jan 2015, GeorgeClark)Edit Attach

Item9343: Variation on TRIM to remove all spaces

pencil
Priority: Enhancement
Current State: Proposal Required
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: SpreadSheetPlugin
Branches:
Reported By: VickiBrown
Waiting For:
Last Change By: GeorgeClark
TRIM reduces multiple spaces to one space. But there needs to be a variant that removes all spaces, e.g. to turn "Hello, world" into "HelloWorld".

I'm looking for the reverse of PROPERSPACE.

This works:
%CALC{$TRANSLATE($SUBSTITUTE($TRANSLATE(a string with comma, and spaces, $sp$comma, $CHAR(29)$CHAR(30)), $CHAR(29)), $CHAR(30), $comma)}%

but oh my that's too complex!

-- VickiBrown - 16 Jul 2010

There appears to be some capitalisation going on, too. This is an enhancement and requires a FeatureRequest. Please link back to this task when one exists.

-- CrawfordCurrie - 08 Sep 2010

Request filed: TrimAllSpaces

-- VickiBrown - 11 Sep 2010
 

ItemTemplate edit

Summary Variation on TRIM to remove all spaces
ReportedBy VickiBrown
Codebase
SVN Range
AppliesTo Extension
Component SpreadSheetPlugin
Priority Enhancement
CurrentState Proposal Required
WaitingFor
Checkins
TargetRelease n/a
ReleasedIn n/a
CheckinsOnBranches
trunkCheckins
masterCheckins
ItemBranchCheckins
Release01x01Checkins
Topic revision: r6 - 04 Jan 2015, GeorgeClark
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy