LTrim
Returns a copy of a string with any leading spaces removed.
Syntax
LTrim(Val)
Parameters
Val
Type: Text
Text value from which you want to remove leading spaces.
(return)
Type: Text
Copy of Val with leading spaces removed.
Remarks
LTrim removes white space (such as space and tab characters) that appears at the beginning of the input string. LTrim uses the rules of the input locale when interpreting white space.
If the current data value is NULL, Val is "" and the return value is "".
How you specify a text string as an argument depends on whether you are using the function in an SQL query or in mrScriptBasic or mrScriptMetadata. In an SQL query, enclose text strings in single quotation marks (' '). In mrScriptBasic or mrScriptMetadata, enclose text strings in double quotation marks (" ").
Example
This example uses the LTrim function to return a copy of the contents of the address variable with any leading spaces removed:
address.LTrim()
See also