README.md

December 5, 2022 · View on GitHub

Super Fast InStr Replacement

Description

This code runs as much as 5000 times faster than VB's InStr function! I've used the Boyer-Moore algorithm which is the fastest string search algorithm in the world. The longer strings you feed this function, the harder it wails on VB's. Switching to vbTextCompare is like lighting the afterburners. Please vote and leave feedback!

More Info

Do not us vbTextCompare mode if one or more of your strings contain ligatures (Æ,æ,Œ,œ,Þ, and þ), the German sharp s (ß), or non-ANSI characters. These characters are considered two characters in vbTextCompare mode and are not easily accounted for by the Boyer-Moore algorithm.

Submitted On2002-01-14 11:11:18
ByChris_Lucas
LevelAdvanced
User Rating4.6 (51 globes from 11 users)
CompatibilityVB 5.0, VB 6.0, VBA MS Excel
CategoryVB function enhancement
WorldVisual Basic
Archive FileSuper_Fast485971142002.zip