edcooper
8 years agoQrew Assistant Captain
I imported a file with a note field. It brought in text with a number of """" in the text field.
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.
"<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.