Remove extra characters

[David Nelson]

I have been asked to do typists' jobs for them. If they put have a paragraph and have more than one carriage return they want it removed. And if it ends or begins with extra carriage returns they want them removed. I have tried auto-enter please see test file. I also need to remove formatting if they paste bold or other sizes and fonts.

It does not work. Is it better to use script trigger?

test.zip

[Kris M]

Substitute ( <data entry field> ; "¶¶" ; "¶" ) will replace two consecutive carriage returns with a single carriage return

Trim( <data entry field> ) will remove extra leading or training spaces

TextFormatRemove( <data entry field> ; format ) will remove the formating.

I would set this as a calculation and replace field contents.

[Lee Smith]

You can use the Substitute function i.e. Substitute (YourTextField; "¶¶" ; "¶" )

[Vaughan]

Go to Brian Dunning's custom function site and get Ray Cologon's Trim4() function. Then make an auto-enter calculation:

Trim4( TextFormatRemove( self ) )

This will remove all leading and trailing white space and remove all text formatting.

[David Nelson]

Thank you Kris and Lee. Yes, that is what I was using in sample file. But if someone had three returns, the substitute would not remove two of them.

Vaughan, thank you! You may be 'Mostly Harmless' but you are also a good adviser. And thank you Ray for the custom function.