Hello,
I have a dimension that has messy data. The dimension we'll call it [Comments].
Comments have data that look something like this (in one cell with multiple lines):
* Marketing campaign in Seattle
- Begin 6/7/2022
1. Revenue growth 20%
I am using NPrinting to display the Comments but it displays as such on the front end:
* Marketing campaign in Seattle - Begin 6/7/2022 1. Revenue growth 20%
My goal is to find the bulletpoint, hyphen, and 1. and creating a next line/break (chr(10))
Using a mixture of pick and wildmatches I get the results I want on a table (testing purposes) in a qlik app with it breaking next line but once bringing that formula into NPrinting, the display reverts to a single line with no line breaks. Any clue or solutions are greatly appreciated.
