I have a long text field. When i inspect it with M...
# suiteanalytics
n
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.
a
just using formula(text) and doing {fieldid} seems to work
n
Thanks for your reply and testing it yourself. Unfortunately no luck for me.
a
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
n
i tried a few things already. REGEXP_REPLACE({message}, '<br[/]?>', '|') REGEXP_REPLACE({message}, '<br>', '|') REPLACE({message}, '<br>', '|')
a
why would you want HTML to show though?
n
we are having to move to a 3rd party printer b/c NS cant handle our print volume of bills
so they need the messages with break lines for bill presentment
a
how are you sending them the data though?.... not through the Ui in a browser right?
cos its the browser that interprets those <br> tags and makes a line break
n
billing staff exports via saved search and uploads it to their print portal
a
huh so the csv export also has the tags removed?
n
yep 😞
a
I wouldn't have expected that
n
even when I look at the csv in a text editor, so it isnt a behaviour of excel or numbers apps
a
can you write scripts?
n
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
a
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
n
yeah but trying to avoid it as this whole thing has been a problem since day one and dont want to own / support it
🤣 1
a
fair
n
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 😂
r
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