Stripping leading carriage return

[overrider]

Hello all,

i have a Text-field which contains multiple lines of Text, for some reason, i often find records where the first line of the text-field contains nothing, i assume it is entered as a carriage return. Is there a simple way to strip this 1 extra carriage return from the beginning of the text-fields content?

Thanks,

Overrider

Edited January 25, 2008 by Guest

[Lee Smith]

You can try the Trim Function, and if that isn't strong enough, then check out the Custom Functions at Brian Dunning's Site called Trim 4

[Nina]

If you can calc the field you could use a leftwords(fieldname, 64000). That will strip of the leading carriage return. The Trim function won't.

[sbg2]

but that will also strip out other characters such as:

&

!

*

^

to name a few.

[Lee Smith]

The custom function I pointed to will do that.

Lee