I imported a file with a note field. It brought in text with a number of "" in the text field.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I imported a file with a note field. It brought in text with a number of
 "<br/>"" in the text field. I need to replace that with a true carriage return(new line).

Here's the note field:
7/26/17 email from Teresa: A/P will be paying w/Amex. They will call in the next few days to take care of it.<br />7/25/17 Teresa hasn't seen it come across her desk yet. Pls email.<br />7/20/17 msg for Teresa Brunson (took care of this last year)<br />8/3/16 Teresa emailed to let me know they are processing the invoice today.
_________________________________
I need it to look like this:
7/26/17 email from Teresa: A/P will be paying w/Amex. They will call in the next few days to take care of it.
7/25/17 Teresa hasn't seen it come across her desk yet. Pls email.
7/20/17 msg for Teresa Brunson (took care of this last year)
8/3/16 Teresa emailed to let me know they are processing the invoice today.
Photo of ed cooper

ed cooper

  • 880 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Try the "enable html" in the text box via the field properties.

That might do it.
Photo of ed cooper

ed cooper

  • 880 Points 500 badge 2x thumb
Well that sure was simple. I've only been working in Qbase for 5 days so I missed that.
Thanks!!