Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi
if(Index(description,'AAA')>0,1,0)
thanks for the answer, but AAA, can be more than 500 different Alias
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;
dont want to compare tables, i want to find text inside those columns.
You can create variable, put your searching text there, and use
if(Index(description,variablename)>0,1,0)
like expression in straight table.
Hi,
You can try this.
PurgeChar(description, ' [ , ] , ' , . , ! ,?' & chr(39)) as ALIES,