Using trim

[rchintala]

I have seen some one suing trim function in the following manner

trim [Expresion, " ", B] but trim function says character specifies a character other than a space or a tab. so please suggest if above usage of trim function trim [Expresion, " ", B] works.

It is all about using trim function is trimming leading and trailing spaces so i suggest that i want to trim[expression]

Please advise which is better option . Also i understand trim is basic function is it advisable to use in parrellel job? if and what should we use

[kandyshandy]

Trim is used everywhere.. server or px !!

[ray.wurlod]

Square brackets indicate optional parts of the syntax. Trim() is a function, so the argument list is surrounded by parentheses, not square brackets.

The third argument to Trim() must be a literal string (that is, quoted) or the name of a variable. In your case

Code: Select all

Trim(Expression, " ", "B")

[rchintala]

Square brackets indicate optional parts of the syntax. Trim() is a function, so the argument list is surrounded by parentheses, not square brackets.

The third argument to Trim() must be a literal ...

Can we use trim trim (Expresion, " ", B). since trim function says character specifies a character other than a space or a tab. but here some one using to trim space.

also I want to check if Trim () is just sufficiant to trim leading and trailing spaces

[laknar]

try this
Trim(Expresion,'-','A')

[ray.wurlod]

Trim() with only one argument trims leading, trailing and redundant white space characters, exactly as described in the documentation.

[vasa_dxx]

If you want to Extract n char from a string, go for Left or Right Functions.
Left(string,Number).

[chulett]

Curious what this has to do with the topic at hand... or are you just delivering random nuggets as early Christmas presents?