I am sure there is a simple solution and a misunderstanding on my part but,

I am trying to delete strings of carriage returns from filemaker so that if someone enters the following:

blah

blah

it will be reformatted to this:

blah

blah

I have tried this and it works to a point:

Substitute ( text_field ; [¶ & ¶ ; ¶] ; [ ¶ & ¶ & ¶ ; ¶] ; [ ¶ & ¶ & ¶ & ¶ ; ¶] ; [ ¶ & ¶ & ¶ & ¶ & ¶ ; ¶])

However, it only works for two of them above that it is useless. I need it to only leave one no matter how many there are... stupid copy and paste!

Thanks for the help!

Edited October 31, 200817 yr by Guest
Soled it by reversing the order... doah!

I do it this way:

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

You show the Sever v7 as your FileMaker version, do you have the v7 Developer Edition, or v8, 8.5 or 9 Advance Edition?

Lee