seperating text

[JBurlison]

i want to separate first and last name, also after doing so automatically generate the e-mail address being first initial, last name. can someone give me and example as to how to do this? or what functions to use?

 

[mresann]

Yes, there are some string functions to use.

You can use this technique directly in a query or in a module using VBA. I'll do the VBA here.

strFirstName="Johhny"
strLastName="Goetz"

strEmailName = Left(strFirstName,1) & strLastName & "@myemail.com"

This returns "JGoetz@myemail.com".

Check out other functions such as Right, InStr, Mid, StrConv, and Chr to name a few.

 

[JBurlison]

im trying to do it the opposite way i have a full name(s) and i want to break them up
Ex i want to make John Todd

Firstname= John
Lastname = Todd

How would i do that?

 

[Mike375]

FirstName: Left([FieldName],InStr(1,[FieldName]," ")-1)

LastName: Right(Trim([FieldName]),Len(Trim([FieldName]))-InStr(1,[FieldName]," "))

 

[doco]

FullName = Trim( FieldName ) ' no surprises
FirstName = Left( FullName, InStr( 1, FullName, " " ) -1 )
LastName = Trim( Right( FullName, Len( FullName) - Len( FullName ) ) )

 

[JBurlison]

thanks guys works like a charm!