Finding string between two column

[#1]

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

end for

any suggestions?

thanks, Loris

[#2]

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

end for

Hope it will help you.

Regards

-Anil

[#3]

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