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

    Finding data within Field



      Finding data within Field


      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


          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




          • 2. Re: Finding data within Field

            "*" & 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...