Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
fsimoes81
Partner
Partner

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

View solution in original post

fsimoes81
Partner
Partner
Author

Thank you!