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 |
|
Johnyalm
Starting Member
49 Posts |
 Posted - 2011-11-25 : 16:38:10
|
| Hi,I would like to get some help with a procedure to loop through a list of emails like this:email@email.comemail2@email.comemail3@email.com.....that are been put into a textarea that then will be parsed and saved in a table one record per email.Anybody that can help me?www.mirrorgate.com |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-11-26 : 08:59:20
|
| Is the "text area" part of a client application such as a VB.Net or C# application? If that is the case, it might be easier to parse it in the C# code, where you have a lot more flexibility and power than you would have in SQL, for example, regular expressions etc.If the data is already in a database table, can you post the sample data? |
 |
|
|
|
|
|
Parse input list of emails