Search found 2 matches

by rchintala
Sat Dec 20, 2008 8:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using trim
Replies: 7
Views: 3304

Thanks ray but my question i little different

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 ...
by rchintala
Sat Dec 20, 2008 6:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using trim
Replies: 7
Views: 3304

Using trim

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 tr...