Splitting name from email address (1 Viewer)

[kupe]

I have a list of email addresses. I want to take the name before "@" and divide it into two if there's a "." or "- " or "_". And to capitalise the first letter of both names.

For example, rob-roy@hootsmon.com would be Rob Roy.

Hope an expert would show me how. Cheers

 

[GeoMetry]

Use instr() to find the location of the @ or . or - then use mid() to extract the part you want. Use Ucase and Lcase to modify the case as required.

 

[kupe]

Many thanks, GeoMetry. Would you bundle this into a Iif?

 

[Rabbie]

check out the Strconv function you can use it to capitalise the first letter of each word in a string. See http://www.techonthenet.com/access/functions/string/strconv.php for more details.