Try using, trim( trailing '.' from trim( col1 ) )
Attachments
Library
Quick Reference
Archives
Sample Index
2005 Indexes