Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!