TRIMALL - problem with spaces in mail text

[Aussie John]

I have noticed TRIMALL(field,0,0) is not removing any spaces if I use text sourced from Apple Mail.  I am thinking that the spaces might have a different type of coding (Maybe I could do a replace before the trimall). Any thoughts?

 

thanks 

[Lee Smith]

Try the cf Trim4 available http://www.briandunning.com/cf/166

[Aussie John]

Try the cf Trim4 available http://www.briandunning.com/cf/166

Thanks Lee - good idea but unfortunately not solving the problem - I wonder how I can tell what the char[] the spaces are.

[doughemi]

Manually count the position of the not-space character and use Code(Middle(theText; position; 1))