how find the count of any 2 keywords in a particular string ?

[#1]

Hi

I have a list of words with column name as keyword. I need to find the no  any two  keywords present in the particular description column what i have with me.

For ex:

List of keywords:

memory,

cpu,

access,

adobe,

outlook

etc

Description:

the cpu memory is full.  (here keywords are 2 )

unable to access outlook. (here keywords are 3 )

[#2]

if i am taking one lakh records it is showing as script failed.

[swuehl]

Sorry, don't get your point.

Are you saying the script starts to fail when you load larger amount of records, like 100.000 records?

And that

if( MatchString>0,'NoActionCalls' ,  'ActionCalls')  as Tickets

does not create a field with the two values?

Have you checked my last attached sample?

[#4]

yes the script fails for large amount of records

[swuehl]

Would you mind sharing the two input files, the ticket dump and the key words?

[#6]

thanks swuehl

its working now

[MarcoWedel]

Hi,

maybe also helpful:

if condition

regards

Marco

[#8]

Hi Swuehl,

Here in the logic we are considering the substring count due to this i guess it is considering the count of words within same single word

for ex:

if the description is like " cpu is down"

then it is checking for a word call ''is'' from the description in the keyword column. But keyword ''is'' actually does not exist, in fact it is picking the word is from the description to the keyword called something like ''issue''

Can you suggest how to avoid this in such case?

[#9]

any response guys?

[oknotsen]

When a question is flagged as answered (in this case even by you yourself), don't expect any more reactions.

If your question has not be answered; don't flag the topic as answered. If you have a new question, start a new topic.

[#11]

Thanks i Dint know that earlier