importing custom field information ??

[james2]

I would like to import/insert data into one of the custom fields depending upon the domain of the email address

To be specific,
- At the moment in the list there are email addresses ending in .com.au but the country field is blank. I would like to insert "Australia" into the this field.

There are about 1000 adresses ( i dont want to do this one by one through the browser).

What is the best way to do this ?

[james2]

Alternatively,
is there an SQL command that could do this ?[/i]

[DW]

Assuming your custom field is field #1, the following command would take care of it for all lists:

update lm_users set user1 = 'Australia' where email like '%.com.au'

[james2]

thanks dean,
the quick response is much appreciated !