GeoffreyHarmuth
9 years agoQrew Captain
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

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