I have a long text field. When i inspect it with Michoel Chaikin's NetSuite Field Explorer, I see it has br to show the break lines. Is there a way to see the br in a saved search? I also tried to use REGEXP_REPLACE and REPLACE to replace it with a special character but no luck.

just using formula(text) and doing {fieldid} seems to work

Thanks for your reply and testing it yourself. Unfortunately no luck for me.

huh, yeah I was not expecting that to work when I did it, it was just step 1 before I started exploring actual formula options

i tried a few things already. REGEXP_REPLACE({message}, '<br[/]?>', '|') REGEXP_REPLACE({message}, '<br>', '|') REPLACE({message}, '<br>', '|')

why would you want HTML to show though?

we are having to move to a 3rd party printer b/c NS cant handle our print volume of bills

how are you sending them the data though?.... not through the Ui in a browser right?

billing staff exports via saved search and uploads it to their print portal

huh so the csv export also has the tags removed?

yep 😞

I wouldn't have expected that

even when I look at the csv in a text editor, so it isnt a behaviour of excel or numbers apps

can you write scripts?

honestly dont really care about it being a <br> but just some unique character to to tell the printer, when you see this character, break line

I'm wondering if you use the n/task module to create a csv export instead of clicking the button in the ui if it will skip the HTML parsing step... I imagine it might

yeah but trying to avoid it as this whole thing has been a problem since day one and dont want to own / support it

fair

they run billing in the middle of the night my time, so if something is "custom" even not related to this, I get the phone call at 3am 😂

Have you tried re-creating the saved search under 'Saved Searches With HTML in Formula(Text)' option. Below is a screenshot of the navigational path