PhpForum
2016-05-20T13:24:00Z
Hello,


Is it possible to split mail and save in the database table? (ex: vsmxxxxxx.com and gmail.com...i need to save in the database from user1@vsmxxxxxx.com and user1@gmail.com),..for identifying user
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2016-05-20T13:28:00Z
Yes, you can do it in Table Triggers or use custom SQL Statements in GeniusConnect for insert/update (Assign Table->Option-SQL commands)

For example this SQL Server syntax will extract the domain from an email address :

RIGHT(EMAILADDRESS, LEN(EMAILADDRESS) - CHARINDEX('@', EMAILADDRESS))
Similar Topics