list.removeEmpty ( )

Function stats

Average user rating
37
400
9999
Support
FileMaker 8.0 +
Date posted
30 July 2016
Last updated
05 August 2016
Version
Recursive function
No

Author Info
 Fabrice

74 functions

Average Rating 4.4

author_avatar



 

Function overview

Prototype

list.removeEmpty  ( _list )


Parameters

_list  a ¶ delimited list


Description

Tags:  Text   List  

Removes all empty values of a list.

Examples

Sample input

list.removeEmpty ( "¶¶Hello¶¶World¶" )


Sample output

Hello¶World

 

Function code

/* list.removeEmpty ( _list )
by Fabrice Nordmann, 1-more-thing
twitter: 1morethingtweet
www.1-more-thing.com

Removes all empty values of a list.

v2, July 2016

*/
Case ( not position ( _list ; ¶ ; 0 ; 1 ) ; _list ;

Let ([
    $cf.list = "\"" & Substitute ( _list ; [ "\"" ; "#DOUBLEQUOTE#" ] ; [ ¶ ; "\";\"" ] ) & "\"" ;
    _result = Substitute ( Evaluate ( "list(" & $cf.list & " ; \"\")") ; "#DOUBLEQUOTE#" ; "\"" ) ;
    $cf.list = ""
];
    _result
)
)


// ===================================
/*

    This function is published on FileMaker Custom Functions
    to check for updates and provide feedback and bug reports
    please visit http://www.fmfunctions.com/fid/400

    Prototype: list.removeEmpty( _list )
    Function Author: Fabrice (http://www.fmfunctions.com/mid/37)
    Last updated: 05 August 2016
    Version: 1.1

*/
// ===================================

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (31)
Date  (28)
XML  (26)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)
Interface  (15)
Layout  (15)
Text  (14)
Variables  (12)
Layout Objects  (11)
Filter  (11)
Design  (10)
Array  (7)