I need to Trim the special Character "
" Tab Char.
I used Trim function ,but throughs me error!!!
Any Suggestions!
Thanks in Advance!
Need to trim Special Character
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Specify the tab character in the Trim() function as the character to be trimmed.
The tab character can be represented as Char(9).
Performance tip: Evaluate Char(9) when initializing a stage variable (perhaps called svTab). Then don't provide a derivation for this stage variable in the main part of the Transformer stage.
The tab character can be represented as Char(9).
Performance tip: Evaluate Char(9) when initializing a stage variable (perhaps called svTab). Then don't provide a derivation for this stage variable in the main part of the Transformer stage.
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.
I could not able to mention the Tab Char in the Trim function. Do i have to mention Char(9) for it?ray.wurlod wrote:Specify the tab character in the Trim() function as the character to be trimmed.
The tab character can be represented as Char(9).
Performance tip: Evaluate Char(9) when initializing a stage vari ...
Thanks,
RAJ
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: