lardawge Posted October 31, 2008 Share Posted October 31, 2008 (edited) 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, 2008 by Guest Soled it by reversing the order... doah! Link to comment Share on other sites More sharing options...
comment Posted October 31, 2008 Share Posted October 31, 2008 I do it this way: Substitute ( TrimAll ( Substitute ( text ; [ " " ; "§" ] ; [ ¶ ; " " ] ) ; 0 ; 0 ) ; [ " " ; ¶] ; [ "§" ; " " ] ) Link to comment Share on other sites More sharing options...
Lee Smith Posted October 31, 2008 Share Posted October 31, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5799 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now