<div>
Does it literally say [db1], or are there different names in the brackets?<br />
<br />
Can you provide a sample file for testing?<br />
<br />
~bp
</div>


Does it literally say [db1], or are there different names in the brackets?

Can you provide a sample file for testing?

~bp

<div>
The files are SQL scripts.. an example would be:<br />
<br />
Use [db1]<br />
<br />
select * from dbo.tb1
</div>


The files are SQL scripts.. an example would be:

Use [db1]

select * from dbo.tb1

<div>
I need to remove the Use [db1] so that I migrate a set of stored procedures to a new schema.
</div>


I need to remove the Use [db1] so that I migrate a set of stored procedures to a new schema.

<div>
I have 625 files which i need to remove &quot;Use [db1]&quot;
</div>


I have 625 files which i need to remove "Use [db1]"

<div>
Thanks for your help....<br />
<br />
When I runt the script I get an eror:<br />
<br />
Line: 11<br />
Char : 4<br />
Error: Input past end of file<br />
Code 800A003E
</div>


Thanks for your help....

When I runt the script I get an eror:

Line: 11
Char : 4
Error: Input past end of file
Code 800A003E

<div>
<div class="content wysiwyg-content">
I have 61 text files in a directory.<br />
<br />
Each text file includes the phrase &quot;Use [db1]&quot;.<br />
<br />
Is it possible to create a vb script which loops through each text file and deletes this phrase?<br />
<br />
&nbsp;
</div>
</div>


I have 61 text files in a directory.

Each text file includes the phrase "Use [db1]".

Is it possible to create a vb script which loops through each text file and deletes this phrase?

 

vbscript edit text file

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.