XORbin ( bin0 ; bin1 ; "" )

Returns the XOR of two binary numbers.

Average rating: 3.8 (50 votes) Log in to vote

Vaughan Bromfield - Show more from this author

Sample input:

XORbin( 11 ; 1001 ; "" )

Sample output:

1010

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// XORbin ( bin0 ; bin1 ; result )
// returns the XOR of two binary numbers.
// the intitial value of result must be empty ("")
// the function returns ? if bin0 or bin1 are empty or non-binary
//
// written by Vaughan Bromfield 
// vbromfield@optusnet.com.au
// 14 March 2010

Let( 

[
exp1 = Case( Length( bin0 ) ≥ Length( bin1 ) ; bin0 ; bin1 ) ; 
pad0s = Filter( 10 ^ Length( exp1 ) ; "0" ) ; 
exp2 = Right( pad0s & Case( Length( bin0 ) < Length( bin1 ) ; bin0 ; bin1 ) ; Length( exp1 ) ) ; 
n = Length( result ) + 1
] ; 


Case( 

Filter( bin0 ; "01" ) ≠ bin0 or Filter( bin1 ; "01" ) ≠ bin1 ; "?" ; // exit invalid parameters

IsEmpty( bin0 ) or IsEmpty( bin1 ) ; "?" ; // exit empty parameters

Length( result ) = Length( exp1 ) ; result ; // exit result completed

XORbin ( bin0 ; bin1 ; result & ( Middle ( exp1 ; n ; 1 ) xor Middle ( exp2 ; n ; 1 ) ) ) 

) // end case

) // end let

A recursive custom function that returns the XOR of two binary numbers. The length of the binary number returned will be equal to the longer of the two binary inputs.

The function returns "?" without quotes if bin0 or bin1 are empty or contain non-binary characters.

Comments

		Vaughan Bromfield Nov 11, 2010
Could the people that rate the function poorly please add a comment to let me know what the disappointment is. Thanks - Vaughan.

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

XORbin ( bin0 ; bin1 ; "" )

Comments

Support this website.

Support this website.