RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hi all,
Got a quandary here. I'm taking a customer pickup as variable, using Chester as an example, and searching for a match within a comma separated list of pickups which may look like this:
I'm searching a large set of data using filters and holding "Chester" as the variable, unfortunately it will show a match for any string that contains *Chester* - including Chichester, Manchester, Chesterfield etc
Any ideas how to search for -just- Chester? In the past I've tried searching for "* Chester*" but obviously this would still count Chesterfield, so you'd think "* [Pickup],*" would work, but this would not work when the pickup needed is at the start or end of the string.
Thank you!
Got a quandary here. I'm taking a customer pickup as variable, using Chester as an example, and searching for a match within a comma separated list of pickups which may look like this:
VBA Code:
Chichester, Bognor Regis, Littlehampton, Worthing, Shoreham-by-Sea, Hove, Brighton, Horsham, Pease Pottage Services (M23), Crawley, Horley
I'm searching a large set of data using filters and holding "Chester" as the variable, unfortunately it will show a match for any string that contains *Chester* - including Chichester, Manchester, Chesterfield etc
Any ideas how to search for -just- Chester? In the past I've tried searching for "* Chester*" but obviously this would still count Chesterfield, so you'd think "* [Pickup],*" would work, but this would not work when the pickup needed is at the start or end of the string.
Thank you!