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
http://www.106sttire.com

Sample input:

1.
RemoveEmptyLines ( "¶¶123¶ ¶456¶ ¶789¶¶" )

2.
RemoveEmptyLines ( "¶¶123¶ ¶456¶ ¶789" )

Sample output:

Return 1:
123¶
456¶
789¶

Return 2:
123¶
456¶
789

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* remove all lines that is empty or just filled with spaces */

Let([
  line = Trim( GetValue( Text; 1) );
  pos = Position( Text; "¶"; 1; 1);
  text2 = If( pos=0; "" ; Right( Text; Length( Text ) - pos) )
];
  Case(
    IsEmpty(line) and IsEmpty(text2); "";  // recursion done.
    IsEmpty(text2); line;    // recursion done with the last line.
    IsEmpty(line) ; RemoveEmptyLines(text2);  // empty line, not in the return
    line & ¶ & RemoveEmptyLines( text2)  // not empty line, add to the return.
  )
)

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.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

RemoveEmptyLines ( Text )

Comments

Support this website.

Support this website.