Page 1 of 1

Trimming end of word returns fm5 through 8

PostPosted: Tue Jul 25, 2006 6:33 am
by David Fox
Hi All,

Is there a Text function which will trim off accidently entered Carriage Returns at the end of a word or line of text, similar to the Trimming of leading and trailing spaces?

Thanks very much and sorry if it's obvious.

Best regards
David

PostPosted: Tue Aug 01, 2006 6:33 am
by John Sindelar
Sure. I use this to remove the last return...

Case(Right(Text; 1) = "ΒΆ"; Left(Text; Length(Text) - 1) ) ; Text )

...and Andrew Parson's custom function to remove returns in between things (like extra returns in a return delimited list).

PostPosted: Fri Aug 04, 2006 2:10 am
by David Fox
Thank you John, as always!

Best regards

David