Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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!