NetSuite Saved Search – Removing <BR> for results

We use a NS saved search to feeds data including tracking numbers into our EDI system.

However, if there is more than 1 tracking number (e.g. multipackage shipment), NetSuite returns the tracking number with a line break tag between each:

TRACKING1<BR>TRACKING2<BR>TRACKING3

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

We need to remove the "<BR>" since they are not part of the tracking numbers and <> are invalid characters for EDI.

We’ve tried the replace function below, but it is yielding "ERROR: Invalid Expression"

REPLACE({trackingnumbers}, "<BR>"," ")

Appreciate any input – thanks!

>Solution :

The formula is a SQL expression. You need to use single quotes (‘) rather than double quotes (") for string literals.

REPLACE({trackingnumbers}, '<BR>',' ')