I have a field that houses an email address. Lets say one of the addresses is [email protected].

What I'm looking to do is create a script to convert this email address to: http://www.lovefilemaker.com.

Accomplished by auto-entering http://www. and then taking all that is past the "@" sign and adding it to the previous, then pasting all in another field.

Sounds simple to script but it's giving me a heck of a time. There has to be an easy solution but I'm not seeing it. Any help?

You might try this:

Let (

pos = Position ( email ; "@" ; 1 ; 1 ) ;

"http://www." & Right ( email ; Length ( email ) - pos )

)

Let(

[$getdomain = Substitute(EmailField;"@";"¶");

$domain=RightValues($getdomain; 1)];

"http://www." & $domain)

Or even ...

"http://www." & GetValue ( Substitute ( email ; "@" ; ¶ ) ; 2 )

:laugh:

I deleted your other post. Please do not multiple post your questions.