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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-10-07 : 10:16:43
|
| Which is the best editor for editing large files? I used recently UltraEdit, it took me around one hour, after tweaking some configurations, to find-replace , a 20GB file.Is anyone using a better editor?Also, I thought, probably using a utility(.exe) would be faster in find and replace than an editor. There are some utilities available on Google, however has anyone done this kind of work? Does anyone use such utility? Kind regards. ------------------------I think, therefore I am - Rene Descartes |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-07 : 13:30:53
|
| Why are you editing files this large in the first place? If you can, import them into staging tables and edit what you need there. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-10-07 : 18:47:14
|
| BULK INSERT or BCP was not able to understand the end-of-line character in the input text file, so I was trying to insert a custom delimeter.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Large import files