Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to search for a substring in each sentence

Hello Everyone,

I am new to qlikview and I need a solution for searching a substring in each sentence.

For example I want to search for a word called DISK from the below sentences:

1. Disk was full.

2. Disk error.

3. Disk space error.

What function can be used to search.Please help.

5 Replies
Highlighted
Master II
Master II

You didn't say what you wanted to do if the word is found.

This will return the position of the word in the string:

= index(FieldWithSentence,'Disk')

Highlighted
Partner
Partner

Hi,

You can try with Match, Mixmatch and Wildmatch.

Highlighted
Not applicable

Hi,

You could take Mike Woolf's answer a bit further...

=If(Index(FieldWithSentence,'Disk') >0,'Found','Not Found');

Highlighted

‌If(sentence like '*Disk*', dosomething, dosomethingelse)

Highlighted
Not applicable

Hi Mike,

What I am trying to get is ,if i use inner join between two tables below

Keyword1Keyword2
cpucpu
batterycpufailure
outlookbattery
rebootupsBatteryfailure
resultemailoutlook
useroutlook
reboot
rebootdone
exchangeoutlook

I am getting the output as

 

Keyword
cpu
battery
reboot

But my expected output is

The words with in the string  also should match and give me the output

the output should be like below:

Keyword
cpu
cpufailure
battery
upsBatteryfailure
reboot
rebootdone
outlook
exchangeoutlook
emailoutlook