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 - 2004-11-12 : 08:13:46
|
| mary writes "I have a 460mb file containing quotes around each field. Please advise if there is a script I can write to remove the quotes and how to do this.Thank you." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-11-12 : 09:09:37
|
| load text file into a temporary 'tablea' (all data in 1 column)update tableaset columa = replace(columna, '"', '')export tablea back to a text file. |
 |
|
|
|
|
|
removing quotes