The trim function removes any leading or trailing spaces from a String or Text, and removes extra spaces from a Text or String, leaving one space separating each word.


The trim function is used to remove excess spaces from a String or Text.




(trim string)

(trim text)

Arguments Name Type Description
Argument:stringString or Text Any String or Text or cell or cell reference that evaluates to a String or Text for which you want to trim extra spaces.


The result string after trimming



Here are a number of links to Lambda coding examples which contain this instruction in various use cases.


Argument Types

Here are the links to the data types of the function arguments.

String Text

Here are also a number of links to functions having arguments with any of these data types.

*= addMethod appendWriteln append
balance binaryInsert binarySearch boolean
char character clean closeLog
code compareEQ compareGE compareGT
compareLE compareLT compareNE compare
comparison compress cons count
date day days360 debugBrowsableProcs
debugDetective debugEval dimension disassemble
display downcase encode evalInSyncLocalContext
eval exportCsv exportSbf exportTab
fdisplay fileClose fileCopy fileDir
fileDisplay fileEraseDir fileErase fileExists
fileMakeDir fileOpen fileReadAll fileReadRecord
fileRead fileSizeOf fileWriteAll fileWrite
filewriteln find hashString hour
importCsv importSbf importTab insert
inside inspect integer isAtom
isBitVector isBoolean isByteVector isCharAlphabetic
isCharAlphanumeric isCharLowercase isCharName isCharNumeric
isCharUppercase isCharWhitespace isChar isCharacter
isComplex isDate isDictionary isDirectory
isEqual isError isFloatVector isIdentical
isInside isIntegerVector isInteger isLambda
isMatrix isMember isMoney isNumberMatrix
isNumberVector isNumber isObjectVector isObject
isPair isPcodeVector isString isStructure
isSymbol isText isType isVector
julian left length list
loadModule loadWorkspace macroReplace makeQuotedList
makeQuotedSymbol member mid minute
money month new number
offset openLog pair parent
parse pointer qt ref
remove replace rept right
run saveImmediate saveModule saveObject
saveRepository saveWorkspace second setCar
setCdr setLastCdr set setf
setq sizeof sort sql
stringCiEQ stringCiGE stringCiGT stringCiLE
stringCiLT stringCiNE stringFill stringToBVector
stringToVector string submit substitute
substringCiEQ substringCiGE substringCiGT substringCiLE
substringCiLT substringCiNE substringEQ substringFill
substringGE substringGT substringLE substringLT
substringNE substring symbolToTypeCode symbol
system text time trim
type uniqueInsert upcase vectorFill
writelg writeln year

Analytic Information Server (AIS)

AIS Component Systems

  • Smartbase Engine
  • QT C++ Libraries
  • MySQL Relational Database
  • AIS Lisp Libraries
  • Rapid Analytic Demo IDE