To separate firstname, lastname and salutation from the names in a table, use:
parse names table="[table name]" namefield="[field name]" FirstNameField=[field name] LastNameField=[field name] SalutationNameField=[field name] limits="[sql clause]" debug
Parameter list information:
Table=[tablename]: The table to parse names in, the default would be the wce_contact table.
NameField=[field name]: The complete name field, default would be Contact for the wce_contact table.
FirstNameField=[field name]: The first name field, default would be firstname for the wce_contact table.
LastNameField=[field name]: The last name field, default would be lastname for the wce_contact table.
SalutationNameField=[field name]: The salutation field, default would be salutation for the wce_contact table.
Limits=[sql clause]: Limits the records that the parse names function is applied to.
Debug: To turn on logging in the WiredContact Errors.log file. Shows the SQL statement that is used.
Test: Use with Debug - if this parameter is included, the WiredContact Errors.log will show the debug information, but no records will be updated.
If a table other than the wce_contact table is specified, then the default values for the name/salutation fields will be those specified in the Table Defaults (Admin...Site Settings...Table Defaults)
|