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 - 2002-03-31 : 22:39:43
|
| Quan writes "To whom it may concern. My question is how to parse a long string with comma and semicolon. For example a string contain name,addr,city,state;. With the comma it will insert into a colum and witht he semicolon it will insert into the next record.For example: John,126 jonh Drive,Evergreen,VA;Joe,456 Joe Street,HomeTown,LA;Smith,123 Street,JamesTown,CA PLease Help,Thanks inadvance.Quan" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-03-31 : 22:39:43
|
| You might try some of these articles (http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv) |
 |
|
|
|
|
|
Parsing a string Insert multiple column and record