Brian Dunning's FileMaker Custom Functions

AddSortOrder ( values ; padWidth ; delimiter ; currentValue )

Add a numeric prefix to a lists of values, with leading 0's for easier sorting

  Average rating: 4.3 (4 votes) Log in to vote

Richard Dyce   Richard Dyce
Dyce & Sons LTD.
http://dyce.com

Share on Facebook Share on Twitter

  Sample input:
AddSortOrder ( "q¶w¶e¶r¶t¶y¶q1¶s¶r¶rt¶t¶j" ; "" ; " - " ; "")
  Sample output:
01 - q¶02 - w¶03 - e¶04 - r¶05 - t¶06 - y¶07 - q1¶08 - s¶09 - r¶10 - rt¶11 - t¶12 - j¶

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

Provides leading-zero numeric prefixing with a definable delimiter.

 

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.