Brian Dunning's FileMaker Custom Functions

FlipDigits ( value )

flips decimal digits for textual sort purposes

  Average rating: 4.0 (35 votes) Log in to vote

Theo Ros   Theo Ros
*
http://notapplicable.com

Share on Facebook Share on Twitter

  Sample input:
FlipDigits ( 1234567890 )
  Sample output:
8765432109

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

Flips all decimal numbers in a Number or Text
9's will become 0's, 8's will become 1's etc.
You can use this for negative numbers when
sorting a list or portal holding numeric values
and when using a textual sort.

Syntax: FlipDigitsr ( value )
Return type: Text

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.