contains_text
Shows TRUE if a string contains an alphanumeric character (a-z, A-Z)
Be the first to rate this function Log in to vote
|
Ben Levitan - Show more from this author
Ben Levitan LLC https://benlevitan.com |
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Often, when working with data that's been OCR'd or parsed from a block of text fields that are supposed to contain only numbers, it contains some letters. This function will flag records that are not fully numeric.
One use is when you OCR a lot of pages of data, text headers and footer, and also column label are imported. This will let you find the specific records that needed to be deleted (column headers, footers) or corrected.
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.