Forum Discussion

GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
9 years ago

Creating line breaks in multiline text field

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
  • 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
  • Nevermind, i figured it out... Just created another formula text field.  Works well.  thanks for this
  • This would be a new text-formula field to mirror your imported field, but in a different format.