Need to trim Special Character

gssr · Post by **gssr** » Wed Nov 25, 2009 1:40 am

I need to Trim the special Character "
" Tab Char.

I used Trim function ,but throughs me error!!!

Any Suggestions!

Thanks in Advance!

ray.wurlod · Post by **ray.wurlod** » Wed Nov 25, 2009 1:42 am

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.

gssr · Post by **gssr** » Wed Nov 25, 2009 3:07 am

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

I could not able to mention the Tab Char in the Trim function. Do i have to mention Char(9) for it?

Thanks,

naveen.p · Post by **naveen.p** » Wed Nov 25, 2009 6:30 am

Could you try these functions with the strip characters

TrimB Remove all trailing spaces and tabs
TrimF Remove all leading spaces and tabs

gssr · Post by **gssr** » Wed Nov 25, 2009 6:49 am

It removes only the spaces, the source file has the "Tab Character" in it

chulett · Post by **chulett** » Wed Nov 25, 2009 8:10 am

gssr wrote:Do i have to mention Char(9) for it?

Yes. And that is the resolution, not a 'workaround'.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 25, 2009 12:17 pm

Were you to follow my advice you would mention, in the Trim() function, the stage variable whose value has been initialized to Char(9).

gssr · Post by **gssr** » Thu Nov 26, 2009 12:28 am

Thank you all. The problem is resolved