trailing characters. Cant get rid
Moderators: chulett, rschirm, roy
trailing characters. Cant get rid
In the final stage of my job where the target is a sequential file(*.dat).
Char SQL Type columns are getting trailed by weird characters that look like small boxes which are highly unprintable.
I can view these in Wordpad but not in textpad.
I have already used the function CompactWhiteSpace,Trim, TrimB,StripWhiteSpace to get rid of these trailing characters.
Nothing seems to work. Is there a special option Im missing in Format properties that could help get rid of these characters.
Pl. suggest. Thanks in advance!
Char SQL Type columns are getting trailed by weird characters that look like small boxes which are highly unprintable.
I can view these in Wordpad but not in textpad.
I have already used the function CompactWhiteSpace,Trim, TrimB,StripWhiteSpace to get rid of these trailing characters.
Nothing seems to work. Is there a special option Im missing in Format properties that could help get rid of these characters.
Pl. suggest. Thanks in advance!
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
i have just tried varchar and that dint seemed to tweak either. When I view the file on the AIX box the string columns don't have any 'weird' trailing characters. When I ftp it over(ASCII mode) they seem to get trailed. They are visible only from wordpad and although notepad seems place blanks in those characters and then concats with the de-limiter.
Thanks!
Thanks!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact: