Not Length( extString ) or PatternCount ( "0123456789" & placeholder Right ( template 1 ) ) Mask ( input Replace ( template Position ( template placeholder 1 1 ) 1 Middle ( input start 1 ) ) placeholder ) PatternCount ( template placeholder ) and ( Length ( Substitute ( input "x" "" ) ) >= start ) PlaceholderCount = PatternCount( template placeholder ) + start ĮxtString = Middle( Substitute ( input "x" "" ) placeholderCount + 1 99 ) There is a companion CF called "DialByWord" that converts uppercase letters into numbers, while ignoring lower-case letters that converts an entry like 800-CALL ATT to a the corresponding alpha-numeric string. Strip non-numeric characters from whatever string is passed to this function using the Filter() function like this. This CF will add any extra digits to the end of the template when the last character is something other than a placeholder. Such feedback may be expecially useful for Federal ID or Social Security Numbers. with "(123) 456-7890" in the field's default text color/style and the characters "123" in BOLD/RED/STRIKE THROUGH, and " !" in the field's default text color/style to indicate that too many digits were entered. It also indicates too many characters when the template's last character is a placeholder. with the three "#" characters in BOLD/RED
Too few characters are indicated by BOLD RED placeholder values for every missing number. This function is designed to provide visual feedback when the user makes an invalid entry. This function takes a string of numeric digits and formats them according to a template string made of non-numeric values (punctuation and/or text) combined with placeholder values to indicate where the numbers will go as they replace the placeholders. Function definition: (Copy & paste into FileMaker's Edit Custom Function window) /*
0 kommentar(er)
