Alphabetising Email Addresses in View Column

[adamwalsh]

I need @DBLookup to pickup the name AB@Company.com BEFORE ABeta@Company2.co.uk in a column view.

I have tried to trim the text before the "@" sign, place it in another column and sort that (whilst unsorting the email address column). By doing so the @DBLookup is no longer using the Email address column as the key, but uses the column containing the trimmed prefix of the Email address (as it is sorted) which is in no way unique....ie: AB@CompanyAlpha.com, AB@CompanyBeta.com (companies do not determine prefixes to be unique nor should they need to).

I'm sure my problem is purely down to the fact that Lotus are using "punctuation" last in their "Column Sort Rules" criteria.

Has anyone encountered this problem before and do they have a solution?

Thanks

 

[pmonett]

Why don't you create another view sorted the way you want, and have your @DBLookup use that instead ?

Pascal.