ListRemoveBlanks ( InList )

Remove blank lines from list (and any ending return). Not recursive.

Be the first to rate this function Log in to vote

Richard DeShong - Show more from this author
Logic Tools
http://logictools.com

Sample input:

ListRemoveBlanks ( "¶Line2¶¶¶Line6¶" )

Sample output:

"Line2¶Line6"

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

Let ( [
   u = Get ( UUID ) ;
   Str = Substitute ( InList ; [ " " ; u ] ; [ "¶" ; " " ] ) ;
   StrTrimmed = TrimAll ( Str ; 1 ; 1 )
] ;
   Substitute ( StrTrimmed ; [ " " ; "¶" ] ; [ u ; " " ] )
)
/*
   Remove all blank lines from list (including an ending return, if any)

   1) Substitute spaces with UUID (this is a preservation step),
      then it subs returns with spaces.
   3) TrimAll reduces consecutive spaces to one (removing blank lines),
      and removes any leading or trailing spaces.
   4) Substitute spaces with returns, and UUID's with spaces.

   Note: In place of Get(UUID), you can use an extremely unlikely string,
   such as: ###AAA$$$999***
*/

Give it a return-delimited list and it will remove any blank values.
It also removes a return at the end of the list (if there is one).

Note about authorship:
This was emailed to fmpExpertsList by Kevin Frank. I just turned it into a CF.

Comments

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

ListRemoveBlanks ( InList )

Comments

Support this website.

Support this website.