DSXchange

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

Trim is used everywhere.. server or px !!

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

ray.wurlod wrote: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

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

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

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

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