Creating line breaks in multiline text field

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
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
Photo of Geoffrey

Geoffrey

  • 1,980 Points 1k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
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
Photo of Geoffrey

Geoffrey

  • 1,980 Points 1k badge 2x thumb
Would I put this in the HTML tag of the multi line text field?
Photo of Geoffrey

Geoffrey

  • 1,980 Points 1k badge 2x thumb
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.