Condense Paragraph - NO Line Breaks

[Dr. Evil]

How could I strip paragraph(s) of all line breaks?

For example, turn:

~

QTY: 1,500

COLOR: Full color front and back

SIZE: 8.5" x 11"

DEADLINE: ASAP

~ to ~

QTY: 1,500 COLOR: Full color front and back SIZE: 8.5" x 11" DEADLINE: ASAP

~

Thank you for your time. Much appreciated.

[comment]

Substitute carriage returns with spaces.

[Dr. Evil]

Substitute carriage returns with spaces.

Yes, this is what I want to do, but don't know how the calculation would look.

[joaocarlo]

You may apply this formula:

​Substitute ( text ; searchString ; replaceString )

Example: Substitute ( MyField ; "¶" ; " " )

More info: FileMaker Help

[Dr. Evil]

Substitute ( MyField ; "¶" ; " " )

Perfect joaocarlo! Thank you!