Discussions

Expand all | Collapse all

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

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

    Posted 09-20-2017 16:05
    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.


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

    Posted 09-20-2017 16:35
    Try the "enable html" in the text box via the field properties.

    That might do it.


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

    Posted 09-20-2017 22:26
    Well that sure was simple. I've only been working in Qbase for 5 days so I missed that.
    Thanks!!