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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Adding quotes to a textfile

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

123456AmandaMorris

and 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.

Arnav
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

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?
Go to Top of Page
   

- Advertisement -