One Part Harmony – FileMaker Database Design, Development, and Maintenance

Custom Functions
Field Clean-Up

The functions in this category can be used to ensure the data stored in fields in the database and data in temporary variables has been “sanitized” -- or “normalized” -- so subsequent code that accesses the cleansed fields and variables can be simplified to expect certain formatting rules to have been followed.

Just click on a custom function name in the list below to see all the details for that function.

Clean_Email( Data )

Calls the Clean_Field function to remove all carriage returns, all text formatting (i.e. font selection, bold, italic, etc.), and leading and trailing spaces from an e-mail address in a field or string. Then, if the actual e-mail address is enclosed in matched punctuation as per the following examples, it extracts just the basic e-mail address, removing the punctuation along with any descriptive name component.

Clean_Field( Data ) [for FileMaker 7, 8, 8.5, 9]

Removes all carriage returns, all text formatting (i.e. font selection, bold, italic, etc.), and leading and trailing spaces from a field or string. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which multiple lines of data might be entered – such as a street address field – use the
Clean_Multi_Line function.

Clean_Field( Data ) [for FileMaker 10, 11, 12, 13, 14, 15, 16]

Removes all carriage returns, all text formatting (i.e. font selection, bold, italic, etc.), and leading and trailing spaces from a field or string. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which multiple lines of data might be entered – such as a street address field – use the
Clean_Multi_Line function.

Clean_Leading( Data ) [for FileMaker 7, 8, 8.5, 9]

Strips all carriage returns, horizontal tabs, and spaces from the beginning of a field or string. This is handy for cleansing user input values of extraneous leading characters before storing the value in a record.

Use the
Clean_Field function to strip leading AND trailing whitespace characters from a field.

Clean_Leading( Data ) [for FileMaker 10, 11, 12, 13, 14, 15, 16]

Strips all carriage returns, tabs, and spaces from the beginning of a field or string. This is handy for cleansing user input values of extraneous leading characters before storing the value in a record.

Use the
Clean_Field function to strip leading and trailing whitespace characters from a field.

Clean_Multi_Line( Data ) [for FileMaker 7, 8, 8.5, 9]

Removes all leading and trailing spaces, carriage returns, and any text formatting (i.e. font selection, text color, bold, italic, etc.) from a multi-line field – such as a street address – while preserving single carriage returns between lines and converting multiple carriage returns between lines to a single carriage return. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which only a single line of data data (no embedded carriage returns) should be entered – such as a name or phone number field – use the
Clean_Field function.

Clean_Multi_Line( Data ) [for FileMaker 10, 11, 12, 13, 14, 15, 16]

Removes all leading and trailing spaces, carriage returns, and any text formatting (i.e. font selection, text color, bold, italic, etc.) from a multi-line field – such as a street address – while preserving single carriage returns between lines and converting multiple carriage returns between lines to a single carriage return. Also any horizontal tabs are treated as spaces, and any new line, vertical tab, and form feed characters are treated as carriage returns while performing this clean-up. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which only a single line of data data (no embedded carriage returns) should be entered – such as a name or phone number field – use the
Clean_Field function.

Clean_Paragraph( Data ) [for FileMaker 7, 8, 8.5, 9]

Removes all leading and trailing spaces, carriage returns, and any text formatting (i.e. font selection, text color, bold, italic, etc.) from a multi-paragraph field – such as a detailed product description – while preserving single or multiple carriage returns between paragraphs in the field. Also any horizontal tabs are treated as spaces while performing this clean-up. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which only a single line of data (no embedded carriage returns) should be entered – such as a name or phone number field – use the
Clean_Field function. For a multi-line field where only a single carriage return is used between lines – such as a street address – us the Clean_Multi_Line function.

Clean_Paragraph( Data ) [for FileMaker 10, 11, 12, 13, 14, 15, 16]

Removes all leading and trailing spaces, carriage returns, and any text formatting (i.e. font selection, text color, bold, italic, etc.) from a multi-paragraph field – such as a detailed product description – while preserving single or multiple carriage returns between paragraphs in the field. Also any horizontal tabs are treated as spaces, and any new line, vertical tab, and form feed characters are treated as carriage returns while performing this clean-up. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which only a single line of data (no embedded carriage returns) should be entered – such as a name or phone number field – use the
Clean_Field function. For a multi-line field where only a single carriage return is used between lines – such as a street address – us the Clean_Multi_Line function.

Clean_Paragraph_Styled( Data ) [for FileMaker 7, 8, 8.5, 9]

Removes all leading and trailing spaces and carriage returns, while preserving any text formatting (i.e. font selection, text color, bold, italic, etc.) for a multi-paragraph field – such as a detailed product description – while also preserving single or multiple carriage returns between paragraphs in the field. Also any horizontal tabs are treated as spaces while performing this clean-up. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which only a single line of data (no embedded carriage returns) should be entered – such as a name or phone number field – use the
Clean_Field function. For a multi-line field where only a single carriage return is used between lines – such as a street address – us the Clean_Multi_Line function.

Clean_Paragraph_Styled( Data ) [for FileMaker 10, 11, 12, 13, 14, 15, 16]

Removes all leading and trailing spaces and carriage returns, while preserving any text formatting (i.e. font selection, text color, bold, italic, etc.) for a multi-paragraph field – such as a detailed product description – while also preserving single or multiple carriage returns between paragraphs in the field. Also any horizontal tabs are treated as spaces, and any new line, vertical tab, and form feed characters are treated as carriage returns while performing this clean-up. This is handy for cleansing user input values of extraneous characters and formatting before storing the value in a record.

For a field in which only a single line of data (no embedded carriage returns) should be entered – such as a name or phone number field – use the
Clean_Field function. For a multi-line field where only a single carriage return is used between lines – such as a street address – us the Clean_Multi_Line function.

Clean_Trailing( Data ) [for FileMaker 7, 8, 8.5, 9]

Strips all carriage returns, horizontal tabs, and spaces from the end of a field or string. This is handy for cleansing user input values of extraneous trailing characters before storing the value in a record.

Use the
Clean_Field function to strip leading and trailing whitespace characters from a field.

Clean_Trailing( Data ) [for FileMaker 10, 11, 12, 13, 14, 15, 16]

Strips all carriage returns, tabs, and spaces from the end of a field or string. This is handy for cleansing user input values of extraneous trailing characters before storing the value in a record.

Use the
Clean_Field function to strip leading and trailing whitespace characters from a field.