REPLACE all <br> in a String with CR()

customaware

I have a String that can contain many <br> s which is normally used in html display.
But I want to use the same string in a plain text of an email notification.
Hence, I want to Replace all of the <br> with a CR().
I thought this should work... but alas... Aware will not accept it.

REPLACE_PATTERN(NP_TripAlertBulletinCustomerTrailerString.TrailerString, '<br>' , CR())

Any ideas would be appreciated.

customaware

Solved it using LIST_LINE and pasting a CRLF in the seperator between records.

NP_TripAlertBulletinCustomerTrailerString.TrailerString = LIST_LINE('FIND CustomerReservationTrailer WHERE CustomerReservationTrailer.ob_CustomerReservation.ob_Customer = Customer AND CustomerReservationTrailer.ob_CustomerReservation.ps_Trip = Trip',' - ', '
' , 'sc_TrailerPlateNumber')