Using Left/Right Function Help

[Steve Railsback]

Greetings all -

I want to pull the user name from an email which will be used for login and web account information.

EX: Entering "[email protected]" into the "emailAddress" field would also populate the "login" field with "someguy" and "web" field with "http://student.school.edu/someguy".

Using the left function does not work because the user name can be 1 to 8 characters long, and the right function only grabs the count from the right.

Any ideas or suggestiongs? Going crazy here and I'm sure there's a simple way to do it.

-steve

[-Queue-]

login := Left( emailAddress, Position( emailAddress, "@", 1, 1 ) - 1 )

web := "http://student." & Right( emailAddress, Length(emailAddress) - Position( emailAddress, "@", 1, 1 ) ) & "/" & login

[Steve Railsback]

Hey thanks! Don't think I could have figured out that one. Played around with it, and found a short cut (well less typing)

web :="http://url/" & Left( emailAddress, Position( emailAddress, "@", 1, 1) -1)

Appreciate the help!

-st

[-Queue-]

Hmm. That will give you http://url/someguy, not http://student.school.edu/someguy, unless I'm missing something.