Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
m_woolf
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')

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

You can try with Match, Mixmatch and Wildmatch.

Not applicable
Author

Hi,

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

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

MarcoWedel

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

Not applicable
Author

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