SeparateStringtypes ( text ; separator )
inserts Separator between numeric and other characters.
Average rating: 4.3 (33 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This function was written to format user-defined product serials that consist of alphanumeric strings. Original question posed here: http://www.filemakertoday.com/com/showthread.php/29875-Separate-text-and-number
The function is recursive. From the rightmost character it compares two adjacent characters and inserts separator where they don't match. Then recurses to the next character by entering the input text minus 1 character.
Please note that any non-numerical character is treated as text, so $% are bracketed in with alpha characters.
jose, Los Angeles, California
Sep 5, 2013
How I can convert a field containing numeric and alpha to text.
Z45 = Z four five
ML7899+ ML seven eight nine nine
642103 = six zero three two one four
7552.32= seven five five two. trhee two
Sep 5, 2013
Well this function was not designed for that purpose. There are to the best of my knowledge various custom functions available here at Briandunning.com that can do what you want. For instance http://www.briandunning.com/cf/106 . That function is not by me and I have not tested it.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.