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

Item9343: Variation on TRIM to remove all spaces

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