Purge chars and find text

[#1]

Hi there!, thanks for your time.

Let me see if i can explain my issue, there we go!

based on a field description that dont have any structure atm, i need to find inside some ALIAS:

subfield(PurgeChar(description, '[]",.!?'), ' ') as ÀLIES

example

Alias to be found: AAA (this is an example, the alias list is arround 500 items)

description: Install AAA on the server one. (description will have one of the 500 alias)

This example is ok, i can be ok i'm able to find this but using the method above but when it comes to AAA-MORE TEXT and so on doesn't

when face other cases like:

Install AAA-app on the server one.

Do i have to install AAA?

-AAA-CCC- Install both

And so on and on

and so on then there is no matching, i've tried to purge - char but no luck.

Huge thanks all!

[pokassov]

Hi

if(Index(description,'AAA')>0,1,0)

[#3]

thanks for the answer, but AAA, can be more than 500 different Alias

[pokassov]

Ok. If you have 2 tables and want to compare them, try this:

t1:

load

     keyfield1,

     description

Resident

     table1;

outer join (t1)

load

     keyfield2,

     Alias

Resident

     table2;

t2:

noconcatenate load

     keyfield1,

     keyfield2,

     if(Index(description,Alias)>0,1,0)     as _find

Resident

     t1;

drop table t1;

[#5]

Hi,

You can see this link.

Qlikview PURGECHAR by RFB 133 - YouTube

[#6]

dont want to compare tables, i want to find text inside those columns.

[pokassov]

You can create variable, put your searching text there, and use

if(Index(description,variablename)>0,1,0)

like expression in straight table.

[#8]

Hi,

You can try this.

PurgeChar(description, ' [ , ] , ' , . , ! ,?' & chr(39))  as  ALIES,