Trim() with options L, T and B.

[thamark]

thamark,

I have my input and output columns defined as Varchar(100). So that's not what is causing it. I even tried

Code: Select all

	Trim(Trim(InCol), 'x','B')

But it still returns:

Code: Select all

AAAAAAAxxxxxBBBBBBBBBBxxxxxxxx

Whale.

Then you can verify to see, if you have some un-printable character at end of the string.

[DSguru2B]

As a test, try giving a hard-coded value to the Trim() function.

[I_Server_Whale]

Then you can verify to see, if you have some un-printable character at end of the string.

You are right. Gosh! I feel embarrassed. I should have checked. There is in fact an unprintable character at the end of the string. I removed it and it works fine.

Ray,

Don't bother digging further.

DSguru2B,

Tried hard-coded. It worked.



Sorry for the false alarm, Folks.

Have a good one,
Whale.

[ray.wurlod]

<unprintable response>

</unprintable response>

[I_Server_Whale]

[balajisr]

Unfortunately that does not work. Thats really odd. But the following works to remove tabs.

Code: Select all

Trim(DSLink17.Num1,'	','L')
Trim(DSLink17.Num1,'	','T')

Thanks for the confirmation. I thought i was the only one having this problem.