Discussions

Expand all | Collapse all

Creating line breaks in multiline text field

  • 1.  Creating line breaks in multiline text field

    Bronze
    Contributor
    Posted 01-06-2017 13:58
    I have data that imports into Quickbase via a websource.  The data represents line items, however when it comes into quickbase the line items are along side each other and seperated by commas (see red square in pic attached).  I would like to have a formula that replaces the "comma" with a "\n" to have each item after the comma on a new line (See green square in pic attached).

    There must be some way of writing some code to do this? basically to say.  After every "comma" start a new line (and delete the comma)

    Please help


  • 2.  RE: Creating line breaks in multiline text field

    Posted 01-06-2017 14:47
    Not tested but try this,

    List("\n",

    part([my text field],1, ","),

    part([my text field],2, ","),

    part([my text field],1, ","),

    .....
    part([my text field],20, ","))



    Just make as many Parts as you think that you need to handle


  • 3.  RE: Creating line breaks in multiline text field

    Bronze
    Contributor
    Posted 01-06-2017 15:13
    Would I put this in the HTML tag of the multi line text field?


  • 4.  RE: Creating line breaks in multiline text field

    Bronze
    Contributor
    Posted 01-06-2017 15:17
    Nevermind, i figured it out... Just created another formula text field.  Works well.  thanks for this


  • 5.  RE: Creating line breaks in multiline text field

    Posted 01-06-2017 15:18
    This would be a new text-formula field to mirror your imported field, but in a different format.