show / hide menu

Trim

This function returns a new string in which all leading and trailing occurrences of a set of specified characters from the current String  are removed.

Syntax:

Trim(Value,TrimValue)

Value is the input String from which a particular character has to be trimmed off. “TrimValue” is the character that needs to be removed from the given input.

Examples:

Trim(TextBox1.Value,”R”)

TextBox1.value=ReaR

The function will return the value ”ea”

Trim functions are case sensitive.