|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
I have a table with a hyperlink field with the client’s email address. Because my client is using Lotus Notes and not Outlook (ugh), I have to prefix each address with mailto: if I want the hyperlink to open Lotus Notes. Currently I am storing the mailto: as part of the field. I want to have a query that lists name and email address without the mailto: listed, but with a comma after each name. I guess they want to export this to their To: field in Lotus Notes.
Any suggestions.
I would change it to :
EmailAddress: Left(,9) & “,” Where does peachent@aol.com[/b] come from?
Pat 
I thought I would do a little further investigation, and I have found that when you view the table’s HyperLink field you don’t see the leading (yes there is a leading #) or trailing # sign. I read a HyperLink field from the table into a variant field and saw these 2 characters.
Your expression should probably be :
Mid(,9,Len()-10)
Pat 
How are you going with this problem, just interested.
Pat
The mid instruction is
Mid([Email],start,length)
Where:
start is where you want to begin taking data
length is how long a string you need to take
Suppose you string looked like
#mailto:thornp.iprimus.com.au#
The start is 9 which is the t of thornp
The length is 30 characters but we only want 30-9 characters, the 9 characters are the #mailto: and the trailing #.
Hope this makes it clear, hmmn…
Pat
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
