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 |
velvettiger
Posting Yak Master
115 Posts |
Posted - 2008-07-17 : 07:53:06
|
Hi Guys,I have a text file which looks like this 123456AmandaMorrisand I would like it to look like this"123456","Amanda","Morris"The file has about 2000 lines how would I go about inserting the quotes and the commas.I use textpad to open the textfile and I am using sql server 2000.Thanks in advance for you help. |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-17 : 08:27:22
|
use editplus.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
velvettiger
Posting Yak Master
115 Posts |
Posted - 2008-07-17 : 09:42:09
|
Hi sunsanvin,I have downloaded editplus and i am using the find in files option. Now inorder to search for multiple ids I tried "12345|45678|78569|78454" and it is not working. Do you have any ideas why it isn't working? |
|
|
|
|
|