Search Tools Links Login

Find, Prompt, & Replace String (Anywhere)

Posted: 2002-06-01
By: ArchiveBot
Viewed: 71

Filed Under:

Visual Basic 6

Title Uploaded Size
Find, 9/3/2020 3:45:00 PM 4,166

This code example will search within any file (even binaries), of your choice, for a string of your chioce, and replace it, with another string of your choice. when it finds a Match to your search, it will Display the last 128 Characters which contain your string. Then it'll Propmt you if you'd like to change this instance(s) of your String. If not, it'll travel onto the next Instance, Display new results, and Prompt you again... I Originally used it in Access VBA, to Insert SQL Formatted dates, into Select statements within SQL Files, before sending them to the pl/sql server. It only took a few moments for me to convert this to work with any filetype. Note that the Replace String shouldn't be longer than the Search String (Commented in Code).

Original Author: Zaphod

Comments on this post

No comments have been added for this post.

You must be logged in to make a comment.