Create URL from email address

[aldipalo]

I'm trying to create a URL from a contacts company email address. I'm using this calculation:

Case (

IsEmpty ( URL ) ;"http://www." & Right(eMail_Address;Length(eMail_Address) - Position(eMail_Address;"|@|";Length(eMail_Address);-1));

""

)

Some of the contact records already have a URL entered so I don't want to change that entry if it exists.

My problem is I do not get any data from this calculation. I have set this up as an Auto Enter calculation in the URL field and unchecked Do not replace existing value assuming the IsEmpty ( URL ) statement will skip the record if there is data there.

What am I doing wrong?

[aldipalo]

Ok, so I created a separate calculation field 'c_URL' with the following:

"http://www." & RightWords ( Substitute ( eMail_Address; "@"; " " ); 1 )

Works fine.

So, I tried entering this into my URL field as an auto enter calc:

Case (

IsEmpty ( URL ) ;c_URL;

URL

)

Still nothing in the URL field.

::

[Fitch]

I assume that you're creating a new record or modifying the email address so the auto enter actually triggers.

Beyond that, why not select the "do not replace" checkbox and ditch the IsEmpty? That should work.

[aldipalo]

I just created a script and replaced all empty URL fields with the c_URL. Took a few minutes, 17,000 records, but it's done. Not perfect, there's a lot of AOL.com and Hotmail.com's, butwe can deal with that later. Thanks.