Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-06 : 00:33:45
|
| Richard writes "windows 2000 server and client (latest sp's) sql7.0 latest sp.table with columns- body|leftside|rightside the latter2 are my working cols and only the first has data- all varchars with body = varchar(8000).The text format in the body column is unstructured. There is an email address somewhere in there.Used charindex on the @ symbol to extract a leftside(name+@ eg rich@) and rightside(domain name eg hotmail.com) column. Then used charindex(' ',rightside) to get a Domain name section of email. Leftside now has the @symbol as the last letter in the string. There are an undefined and different number of words and spaces before that. How do I get the first half of the email address?" |
|
|
|
|
|
email extraction from undefined string