Then you can verify to see, if you have some un-printable character at end of the string.I_Server_Whale wrote:thamark,
I have my input and output columns defined as Varchar(100). So that's not what is causing it. I even triedBut it still returns:Code: Select all
Trim(Trim(InCol), 'x','B')
Whale.Code: Select all
AAAAAAAxxxxxBBBBBBBBBBxxxxxxxx
Trim() with options L, T and B.
Moderators: chulett, rschirm, roy
Re: Character datatype
Hmm i will fill this when ever i get one
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Re: Character datatype
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.thamark wrote:
Then you can verify to see, if you have some un-printable character at end of the string.
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Ray,
Don't bother digging further.
![Sad :(](./images/smilies/icon_sad.gif)
DSguru2B,
Tried hard-coded. It worked.
Sorry for the false alarm, Folks.
Have a good one,
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Thanks for the confirmation. I thought i was the only one having this problem.DSguru2B wrote: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')