NaturalToOriginal ( value ; cont )

Converts "natural" values to values

Average rating: 5.0 (1 vote) Log in to vote

Ãngel MartÃnez FernÃ¡ndez - Show more from this author
Lesterius Barcelona
https://www.lesterius.es/

Sample input:

NaturalToOriginal ( "abc0000000123¶zyx0000000001" ; 1 )

Sample output:

abc123
zyx1

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

/*
* Purpose: Convert narutal values to values
* Autor: Angel Martinez Fernandez, Atatiki Group
* Version: 1.0
*
* Params:
* -value: Natural value
* -cont: Recursive number
*
* Vars:
* -item: Number in Natural value
* -size: Number of "0" to remove
* -zeros: Text to remove
*
* Notes: Supports lists, max number length of a value is 10
*/

Let (
[

item = GetAsNumber ( GetValue ( value ; cont ) );

size = 10 - Length ( item );

zeros = Case (
size = 1 ; "0";
size = 2 ; "00";
size = 3 ; "000";
size = 4 ; "0000";
size = 5 ; "00000";
size = 6 ; "000000";
size = 7 ; "0000000";
size = 8 ; "00000000";
size = 9 ; "000000000";
""
)

];
Substitute ( GetValue ( value ; cont ) ; zeros & item ; item ) & If ( cont < ValueCount ( value ) ; "¶" & NaturalToOriginal ( value ; cont + 1 ) )
)

Natural sort is good but we need to convert the values back to normal.

Comments

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

NaturalToOriginal ( value ; cont )

Comments

Support this website.

Support this website.