Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
fsimoes81
Partner - Contributor III
Partner - Contributor III

Word Search (Whole Word)

Word Search,

I need find a string inside a text, but need to be a whole word.

Like this example:

ModelCompany Model

24H

Wheel Loader 924H
924HWheel Loader 924H

On example, I need take de seconde value, to use Left(), Right(), Index(), etc, is not possible, because this is a simple example, mas has many variations.

If SubstringCount() or WildMatch(), allowed "whole word" would be perfect.

Some sugestion, please?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like attached?

Use an appropriate delimiter that is not part of your strings (I used '~' for that).

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe like attached?

Use an appropriate delimiter that is not part of your strings (I used '~' for that).

fsimoes81
Partner - Contributor III
Partner - Contributor III
Author

Thank you!