topic Finding string between two column in QlikView

Finding string between two column

Fri, 19 Oct 2012 15:09:23 GMT

Hi all,

i have 2 table the first contains a set of string, without space,

the second contains a more complex string,

i have to find which row of the second table is composed with string from the first table.

kind of :

for each tab1.col1

for each tab2.col2

if tab2.col2 contains tab1.col1

than tab1.col2 = tab1.col2+1

end if

end for

any suggestions?

thanks, Loris

Re: Finding string between two column

Fri, 19 Oct 2012 15:47:32 GMT

Hi loris_np,

If you are serching somthing like find method of ado or ado.net then sorry. but you can use index function with in for .. next

for each tab1.col1

for each tab2.col2

if index(tab2.col2,tab1.col1)<>0 than tab1.col2 = tab1.col2+1

end if

end for

Hope it will help you.

Regards

-Anil

Re: Finding string between two column

Tue, 23 Oct 2012 09:31:04 GMT

there is a function : SubStringCount (text, sub_string) that works good for me...

but i don't know if it's possible to make a cycle over a column (in script phase), in this case i could just make a sum of SubStringCount for each tab1.col1.

someone have a code snippet that could help me ?

thanks, Loris