Remove newline from text

Home Forum Formula and Condition Editor Remove newline from text

This topic contains 3 replies, has 0 voices, and was last updated by  Laura Debello 7 years, 1 month ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #834

    Laura Debello
    Participant

    Hi,

    I have 2 fields; one is a multi-line field and the other is a text field. I need to be able to copy the data from the multi-line field to the text field and remove any newlines or carriage returns.

    The multi-line field will typically contain an address; such as:

    ABC Company P/L

    Lvl 12, 100 City Road

    Sydney NSW 2000

    And I need this to copy to the text field as:

    ABC Company P/L Lvl 12, 100 City Road Sydney NSW 2000

    I have tried using replace but it doesn’t recognise regexp “n”.

    Do you have any suggestions?

    #5873

    If you need all of it in one text input field, I would create individual text inputs for Street, City, State/territory, and zip. Then Use a formula in a Set Field to concatenate them all into one field.

    Workflow software, Process software, Procedure software

    #5874

    pmeidinger
    Participant

    Try using [rn] (including the brackets) in the Pattern parameter of the Replace function to match the newline.

    #5875

    Laura Debello
    Participant

    Hi pmeidinger, Thank you so much for this, it worked! You’re a champ!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.