How can I compare 2 fields and delete ONLY the common part of a text string?
It might be at the beginning or the end of the string.  The "Pattern Count"
function seems to want to return a number.  Is there a way to do this>

                        Example  A
Field 1:      2527 Sunbean Dr
Field 2:      2527 Sunbean Dr  Sandy Point, WA  98005
           into
Field 1:      2527 Sunbean Dr
Field 2:      Sandy Point, WA  98005

                        Example  B
Field 1:      Sandy Point, WA  98005
Field 2:      2527 Sunbean Dr  Sandy Point, WA  98005
        into
Field 1:      Sandy Point, WA  98005
Field 2:      2527 Sunbean Dr


TIA

ZAQ

Use the substitute function, as in:
    substitute(Field2, Field1, "")

zaqq1111@yahoo.com wrote:

> How can I compare 2 fields and delete ONLY the common part of a text string?
> It might be at the beginning or the end of the string.  The "Pattern Count"
> function seems to want to return a number.  Is there a way to do this>
> 
>                         Example  A
> Field 1:      2527 Sunbean Dr
> Field 2:      2527 Sunbean Dr  Sandy Point, WA  98005
>            into
> Field 1:      2527 Sunbean Dr
> Field 2:      Sandy Point, WA  98005
> 
>                         Example  B
> Field 1:      Sandy Point, WA  98005
> Field 2:      2527 Sunbean Dr  Sandy Point, WA  98005
>         into
> Field 1:      Sandy Point, WA  98005
> Field 2:      2527 Sunbean Dr
> 
> 
> TIA
> 
> ZAQ
> 
> 

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance