I feel like I've seen this on here recently, but can't find it.

Can anyone provide a way to filter out null values from a list of values?

"¶¶ABC¶123¶123¶¶¶EFG¶" should return "ABC¶123¶123¶EFG"

Thanks

This is my preferred method:

Substitute ( TrimAll ( Substitute ( listOfValues ;  [ " " ; "§" ] ; [ ¶ ; " " ] ) ; 0 ; 0 ) ; [ " " ; ¶]  ; [ "§" ; " " ] )

One possible way:

Substitute ( TrimAll ( Substitute ( text ; ¶ ; " " ) ; 0 ; 0 ) ; " " ; ¶ )

UPDATE: Actually, the concept came from Comment's mind but the calc is my twist on it ... his was, of course, shorter and sweeter. But the idea is to change the carriage returns (or any character wanted) into spaces. Then remove the extra spaces. Then turn it back into carriage returns.

Edited November 13, 200817 yr by Guest
Added update

:blush2: oooops, hi Michael.

Thanks guys!

Maybe this is a stupid question, Comment, but I noticed in your sample code that you used three open parentheses and only one close. Why is that? When do close parentheses matter, and when don't they? (Before posting this, I looked in two FMP books and quickly searched FMForums, but at first glance I didn't find an answer.) Thanks!

No, there are three functions used, and three open/close pairs of parentheses.

: Dude! My new eyeglasses are doing more harm than good.

One other, possibly stupid Q, if you don't mind - how did you get your code to display in color like that - is that a post-FMP7 feature?

Thanks again.

It's a forum feature - I have no control over it.