how do I trim an email input address so only the data before the @ is inputted into the database?

Question

I am using coldfusion 9 to add data into a MySQL database from a form.

I would like to create a username from the email address inputed into the form.

for example,

<cfset store_user_email = EMAILADDRESS>
<cfset store_username = trim EMAILADDRESS before the @>

I'm not sure how to trim down the email address?

Any help would be much appreciated.

You have 5 questions and have not accepted a single answer. I suggest you start marking some of them or the free help will dry up. FYI- I haven't answered any of them that I know of, so I don't have a dog in the hunt, I'm just letting you know. — Nate, Jul 21 '11 at 21:45

score 8 · Answer 1 · answered Jul 21 '11 at 11:48

8

<cfset store_username = trim(listFirst(EMAILADDRESS,"@"))>

answered Jul 21 '11 at 11:48

Henry

3

The List functions are very powerful if you can get your head around a string as a list. – ale Jul 21 '11 at 12:21
Many thanks for your quick response, that has worked a treat. – elixireu Jul 21 '11 at 14:14

1 Answers1