Brian Dunning's FileMaker Custom Functions

SortableTextWithNumbers ( text )

Returns an alphanumeric string suitable for sorting mixed numbers and characters

  Average rating: 4.4 (22 votes) Log in to vote

Daniele Raybaudi   Daniele Raybaudi
ACI
http://www.aci.it

Share on Facebook Share on Twitter

  Sample input:
12.3b
123b
2b
0
  Sample output:
00000000123000000000b
00000001230000000000b
00000000020000000000b
00000000000000000000

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

Returns an alphanumeric string suitable for sorting mixed numbers and characters.

 

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.