trim

Description

Removes whitespace from both the start and end of a string.

Syntax

Like many functions in DataPrime, trim supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

Function notation

trim(value: string): string

Method notation

(value: string).trim(): string

Arguments

Name	Type	Required	Description
value	string	true	The string to trim

Example

Clean up an extracted username

Use trim to remove the extra spaces:

Example data

{
  "username": "    SyntaxTerror    "
}

Example query

Function notation

create trimmed_user from trim(username)

Method notation

create trimmed_user from username.trim()

Example output

{
  "username": "    SyntaxTerror    ",
  "trimmed_user": "SyntaxTerror"
}