20/11/2006 This formula (introduced into release 2.893)  is a fix for the 'From" field to allow the lookups to work correctrly for emails sent from some POP3 clients
Some clients set the FROM field to "David Spence <ds@crossware.co.nz>" which will make the lookups fail. This formula change will
ensure that the display name is stripped if present. Enter this formula into the (!From!) lookup configuration'



strFrom:=@If(@Contains(From;'<');@Middle(From ;'<' ;'>' );From);@If(Principal='';strFrom;Principal)



NOTES.

1. This formula MUST NOT contain carraige returnds when entered into the Document
2. All lookups MUST be refreshed for the changes to take affect(Use the refresh configuration documents action)