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 |
|
v_kash
Starting Member
45 Posts |
 Posted - 2012-08-28 : 14:55:20
|
| Ok - i hope someone can help with this. I've taken an Excel File and am trying to clean it up before loading it into a table. One of the columns (email address)does have carriage returns and line feeds. I have a derived column that cleans it up. My ? is this - for example, there can be more then 1 email address in the email address column. So the value can be VVVV@Gmail.com XXXX@ymail.com. What I want to do is to remove the extra spaces between that value, and place a semi-colon between them. Now, the # of blank spaces between these values can vary, which is the trouble-some part. Any ideas? Thanks |
|
|
v_kash
Starting Member
45 Posts |
Posted - 2012-08-28 : 16:46:48
|
| Hopefully someone can help!!!! This is stumping me |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-29 : 13:20:17
|
| why not put result from excel as it is in a staging table and then do clean up using sql procedure invoked from execute sql task?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Derived Column Issue