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
Using trim
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks ray but my question i little different
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.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 ...
also I want to check if Trim () is just sufficiant to trim leading and trailing spaces
Ranga chintala
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: