Function to remove blanks from list

[David Jondreau]

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

[comment]

This is my preferred method:

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

[LaRetta]

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, 2008 by Guest
Added update

[LaRetta]

:blush2: oooops, hi Michael.

[David Jondreau]

Thanks guys!

[alterbentzion]

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!

[comment]

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

[alterbentzion]

: 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.

[comment]

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