by Zaphod (7 Submissions)
Category: Complete Applications
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating:
(2 Votes)

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