August 24, 201114 yr 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.
August 24, 201114 yr Author Substitute carriage returns with spaces. Yes, this is what I want to do, but don't know how the calculation would look.
August 24, 201114 yr You may apply this formula: Substitute ( text ; searchString ; replaceString ) Example: Substitute ( MyField ; "¶" ; " " ) More info: FileMaker Help
Create an account or sign in to comment