Reformatting emails

[DPS]

I am importing emails and the "from" field shows up in this format: john smith , I need to strip all the first characters and < > off so that the email reads: [email protected]

Is there an easy way to do this?

[comment]

There are a number of ways to do this, here's one:

Let ( [

start = Position ( From ; "<" ; 1 ; 1 ) + 1 ;

end = Position ( From ; ">" ; start ; 1 ) 

] ;

Middle ( From ; start ; end - start )

)

[DPS]

That worked just great. Thanks!

[DPS]

OK, now I have reached my next challenge.

The "To" field can sometimes have multiple addresses and they formatted like this:

, ,...

Is there a way of separating these and putting them as several repetitions in a single field?

[sbg2]

use a Let function and the substitute function twice. once to replace "<" with nothing (ie. "") and the second to replace ">, " with a return (pillcrow).

[DPS]

I have another dilemma:

I have two tables. One with my "contacts" and one with all the emails I import. I then create a realationship with the email address so that when I am on the contact card it displays all the sent and received emails for that contact. That part is easy.

What I now want to do is find all the "orphan" emails in the database. This is all the emails that where imported and do not have a proper made up contact card for them. I want to find them in order to create the contacts or delete the emails if they are irrelevant.

[sbg2]

Since you already have a relationship by email address... go to your email table layout, put the field CONTACTS::email on the layout and do a find by putting the = (equals) sign in that field.