Software Venture Consulting
ToMarket

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

XORvalues ( ListA ; ListB )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 3.6  (17 votes)
  Discuss this Custom Function

Ray Cologon, NightWing Enterprises
http://www.nightwing.com.au/FileMaker

Returns all lines that are different in two lists.

Sample Input:
XORvalues ( "Apple¶Pear¶Orange¶Banana"; "Lemon¶Apple¶Orange¶Grape" )
Sample Output:
Pear
Banana
Lemon
Grape


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

This function returns a single instance of all lines that are in ListA but not in ListB *and* of all lines that are in ListB but not in ListA. In other words lines that are in either field but *not* in both.

XORvalues has many applications in complex text processing, including but not limited to comparison of value lists (and lists of field values) in the synchronization of databases.

Note that a useful spin-off is that if one of the supplied parameters is null (""), the function will operate to return UNIQUE values from the other list - Ie it will eliminate duplicates. A single instance of each value will be returned, in the order of their first occurrence in the list.

The function as set out here is 'tuned' to return a combined list without a trailing carriage return. This behavior can readily be adjusted to line up with FileMaker's other 'values' functions if preferred.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

Is it possible to use this funtion and just have the items that are different in List B to List A returned? At the moment it returns differences between the two which I am using to see what has changed. I am trying to report changes but only want what it has changed "to", as it currently stands I am getting "changed to and changed from" which is useful in other reports but in this instance I only want to see what is different in list B when compared to List A. Any help appreciated.

Katy Butterworth, New Zealand
October 01, 2009 3:50pm

If A = (1,2,3) and B = (2,3,4);

XOR( List( A; B); A)

Bruce Robertson, Redmond
June 17, 2010 12:32pm

Note: This function will wipe out any of the "·" characters (ASCII 225) you might have in your value list. Unlikely, but important to note side effects like this.

Daniel A. Shockley, New York, NY
November 16, 2010 11:15am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 8 + 7 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. list.intersect (listA; listB)
  (Mon, May 14, 12:43pm)
2. WeekStart ( weekOfYear ; year )
  (Sat, May 12, 8:42am)
3. PercentToWords (FIELD)
  (Thu, May 10, 3:16pm)
4. PercentToText (FIELD)
  (Thu, May 10, 2:37pm)
5. StripReserved( text )
  (Wed, May 02, 6:05pm)
6. ListBaseTables
  (Wed, May 02, 3:48pm)
7. ValidEmail( theEmail )
  (Wed, May 02, 7:27am)
8. UltraDate (Text; LongDate_or_DateDigit)
  (Wed, May 02, 6:07am)

RSS Feed of Custom Functions