Leading comma in email addresses

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

My email addresses that are imported have a leading comma in them.

How do I fix?

#2

Here is a screen shot

This is happening when I try to reply to email in suitecrm. When I try to reply it errors

Thanks

#3

Hi,
If in the import the comma was added, you can run a database query to remove this trailing comma. You can use Mysql REPLACE function. Or you can write your own Custom PHP Script for addresses parsing.

The table to parse will be

email_addresses

You can modify the “email_address” and “email_address_caps” columns

Thnaks

#4

Thank you!

However, this is happening when it’s gathering email from an account. Not when doing a bulk import. Sorry for the mis-report