2 Replies Latest reply: Oct 23, 2012 5:31 AM by Loris NullPointer RSS

    Finding string between two column

      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

        • Re: Finding string between two column

          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