RemoveEmptyLines ( Text )
Remove all empty lines or lines with only spaces
Be the first to rate this function Log in to vote
Philip Wang - Show more from this author
106th Street Wheel and Tire
RemoveEmptyLines ( "¶¶123¶ ¶456¶ ¶789¶¶" )
RemoveEmptyLines ( "¶¶123¶ ¶456¶ ¶789" )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This function is similar to RemoveExtraReturns at http://www.briandunning.com/cf/11
But it adds processing line feature. You can remove other unwanted characters like Tab or CR.
Note: If the value list is ended with more than 1x¶, the result will have a ¶ in the end. As the samples show.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.