Find end of line in text field?

[JMP]

Anyone know if it's possible to search for and replace an the end-of-line in a text field when the field has only a single line of text?

[CobaltSky]

Hello JMP,

I assume that you mean that you want to remove a carriage return character which is at the end of a single line of text.

If so, you could use the formula:

If(Right(YourTextField, 1) = "

[-Queue-]

Alt

Left( YourTextField; Length(YourTextField) - (Right( YourTextField; 1 ) = "

[CobaltSky]

Yes. Neat!

Or, if the text field is not expected to have trailing punctuation:

LeftWords(YourTextField, 99)