2 Replies Latest reply on Mar 20, 2012 10:32 AM by blewvelvet

    Finding data within Field

    gsbilsky

      Title

      Finding data within Field

      Post

      I am trying to update TableOne::FieldTwo based on the following information.

       

      TableOne::FieldOne has long string of data containing alpha, numeric, and/or dates.

       

      TableTwo::FieldOne has short string of data matching within TableOne::FieldOne.

      TableTwo::FieldTwo has information to be placed in TableOne::FieldTwo.

       

      I have created the two table and can match if TableOne:FieldOne and TableTwo::FieldOne are exact matches.  But I only want partial matches.

      How do I set the relationships?  How do I match partial information?

       

      Should I set a Script and run it to up update TableOne::FieldTwo?

       

      I am currently trying the following:

       

      If ("*" & BankData::BankPayee & "*" = Payees_W_Cats::WherePayee; Payees_W_Cats::ReportingPayee ; "")

       

      What am I doing wrong?  What should my relationships be?

        • 1. Re: Finding data within Field
          kapitaen_1
            

          hi,

          what you want can not be done by a relation.

           

          relations are always exactly equal, non-equal, lower, bigger, crossjoin. but not partly equal.

           

          you must make a script that takes the search criteria from table 1, and searches in table 2 for "*" & criteria & "*"

           

          greetings from germany

          chris

           

           

          • 2. Re: Finding data within Field
            blewvelvet

            "*" & criteria & "*"

            ...does not work.

            Is that typed correctly?Can that be used in a script?

            Maybe I'm using this for the wrong purpose.

            I need a script to basically say:

            If "field" contains "anyOFthisText"...then...