RemoveCRNL ( TextField )
Removes a trailing CR or NewLine from text
Average rating: 4.3 (24 votes) Log in to vote
FM Database Consulting
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Many times users will hit the return or enter key to navigate to the next field, especially with IWP, which can cause problems with exact (==) searches in FileMaker. This function tests the text field for a trailing CR or NL and removes it.
6-27-12 - Added default of 'TextField' to the function.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.