create a next line after a specific character

[ymcmb]

Hello,

I have a dimension that has messy data. The dimension we'll call it [Comments].

Comments have data that look something like this:

* 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. 

[vinieme12]

try modifying the field itself in your data load editor

Load replace(replace(replace(dummy,'*',chr(10)&'*'),'-',chr(10)&'-'),'1',chr(10)&'-') as newdummy inline [
dummy
* Marketing campaign in Seattle - Begin 6/7/2022 1. Revenue growth 20%
];